To update your SQL database definition to a newer release of Query Processor, run the new version of the Schema Administrator with the UPDATE command. You can also use the UPDATE command to update the level of Enterprise Database Server software. Here is an example of using the Schema Administrator to UPDATE an SQL database:
RUN *SYSTEM/MCPSQL/ADMIN("UPDATE 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.
