ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-37
USERCAT UPGRADE Statement
Effects of SYSCAT UPGRADE
SYSCAT UPGRADE makes the following changes to the system catalog:
•
Alters the definition of the following tables and supplies a default value for each
new column: ZNSUS, ZNSDB, and ZNSPROF
•
Renames ZNSTRC to ZNSTRA and ZNSDT to ZNUDT
•
Adds the following tables:
•
Adds mapping entries for these objects
•
Updates the database version value in ZNSDB
•
Generates an error if the specified catalog is not a NonStop ODBC Server version
100 or 110 catalog
USERCAT UPGRADE Statement
Use the USERCAT UPGRADE statement to change the mapping tables so that the
specified user catalog conforms to the current version specification.
USERCAT UPGRADE has the following syntax:
catalog-name
specifies the catalog to be upgraded. If you omit catalog-name, the catalog in
the current subvolume is used by default.
Example
The following statement shows the use of USERCAT UPGRADE:
usercat upgrade \test.$vol2.persnl
Effects of USERCAT UPGRADE
The USERCAT UPGRADE statement makes the following changes to the system
catalog:
•
Adds mapping entries for new objects in ZNUOBJ
•
Adds ZNUDT table
•
Updates the database version value in ZNSDB
ZNSCON ZNSGOV ZNSSER ZNSSCS ZNSUMAP
ZNSDEF ZNSNET ZNSSCFG ZNSSMAP
USERCAT UPGRADE [ catalog-name ]