Schema Database management through direct schema tables manipulation
The following steps summarize the procedure to configure the Schema Database using SQL queries against the schema tables.
1. Add entries in OA_TABLES and OA_COLUMNS tables with table definitions for your IP. Your schema files will be in the schema/yourip directory you configure as part of setting up to implement your IP.
Refer to "Setting up to implement an IP" in Chapter 1 of the OpenAccess SDK Programmer’s Reference for your language.
2. Add entries into the OA_STATISTICS and OA_FKEYS tables. Note the fields that are required by the OpenAccess SDK SQL engine.
3. Add entries into the OA_PROC and OA_PROCCOLUMNS for the stored procedures that your IP will support.
