Examples

The following examples describe how to use the OAViewgen tool for generating view definitions.

Example A

Schema path location and version arguments are specified for generating view definitions.

To generate view definitions:

At the command prompt, go to \[installdir\]\\ip\\bin and enter the following command.

OAViewgen "C:\\Program Files\\Progress\\DataDirect\\oaserver81\\ip\\schema\\csv\\" –v 8.1

All the views present in the view.dat file, which is placed at C:\\Program Files\\Progress\\DataDirect\\oaserver81\\ip\\schema\\csv\\, are extracted and an OA_8.1.sql file is generated at C:\\Program Files\\Progress\\DataDirect\\oaserver81\\ip\\schema\\csv. This SQL file contains all view definitions.

Example B

Schema path location, version, and file_name arguments are specified for generating view definitions.

To generate view definitions:

At the command prompt, go to \[installdir\]\\ip\\bin and enter the following command.

OAViewgen "C:\\Program Files\\Progress\\DataDirect\\oaserver81\\ip\\schema\\csv\\" –v 8.1 –f viewddls.sql

All the views present in the view.dat file gets processed and a viewddls.sql file is generated at C:\\Program Files\\Progress\\DataDirect\\oaserver81\\ip\\schema\\csv.