To update your Enterprise Database Server database that was previously generated with the SQLVIEW command, run the new version of the Schema Administrator with the SQLVIEW command. Here is an example of using the Schema Administrator to perform this task:
RUN *SYSTEM/MCPSQL/ADMIN("SQLVIEW DATABASE <database name>
:ACCESSCONTROL=UPDATEOK"); | Note: | For more details on running the ADMIN utility, see the Relational Database Server for ClearPath MCP Query Processor Programming Guide. |
This will create a new DESCRIPTION/<database name>/MCPSQL-CATALOG file and replace the old one.
Run the following command if you made changes to the SQL schema (such as renaming a column or table) and want to preserve those changes:
RUN *SYSTEM/SQL/ADMIN ("SQLVIEW DATABASE <database name>
:ACCESSCONTROL=UPDATEOK");
FILE CARD=DDLRESULTS/<database name>/SEMANTIC
