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.