skip to main content
Configuring the OpenAccess SDK SQL Engine : Migrating Views to OpenAccess SDK 8.1 and later : Generating View Definitions
 

Generating View Definitions

To generate view definitions:
At the command prompt, go to [installdir] \ip\bin and type the following command:

OAViewgen <schema path location> -v < Version> [ -f <file_name> ].
For example, OAViewgen "C:\Program Files\Progress\DataDirect\oaserver81\ip\bin\" –v 7.2
Table 11. Generating View Definitions Command Parameters
Arguments
Description
<schema path location>
The location of view.dat and oa_columns.csv file.
Note: Both the files should be at one location.
v<version>
Supported values are 7.0 and 7.2.7.0: For OpenAccess product versions prior to 7.0.1.07.7.2: For OpenAccess product versions 7.0.1.07 or above.
-f <file_name>
The output file name to store the generated view definitions. If the file name is specified, the tool creates a file with the specified name and stores the generated view definitions in it. If the file name is not specified, the tool, by default, creates a file with name: OA_<version_input>.sql. For example, OA_7.0.sql.
Note: This argument is optional.
Note: If this file already exists, the generated view definitions are appended to this file.