ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-30
USERCAT REFRESH Statement
•
You create the object using NonStop SQL/MP when the catalog is already
customized.
•
You delete a row from the NonStop ODBC Server mapping table ZNUOBJ.
You can refresh the system catalog if you delete a row from the ZNSDB mapping table.
USERCAT REFRESH re-creates the mapping entry for the customized catalog and
refreshes the object mapping table for the system catalog.
USERCAT REFRESH has the following syntax:
catalog-name
specifies the name of the subvolume containing the NonStop SQL/MP catalog to
be refreshed. The catalog-name must be in Guardian format and can include the
node and volume. There must be an entry in ZNSDB for catalog-name and the
catalog must be the most current version. If the entry for catalog-name is
missing in ZNSDB, you must first execute USERCAT INSTALL to create the entry.
If the catalog is not the most current version, you must first execute USERCAT
UPGRADE to upgrade the catalog version.
If the specified subvolume contains the system catalog, the mapping tables in the
system catalog are refreshed.
If the specified subvolume does not contain a customized catalog, an error
message is generated and the statement is not executed.
If you omit catalog-name, the current subvolume is used.
output-filename
specifies the NonStop SQL/MP table name of the log table where command
response messages are written. The log table is an unaudited, entry-sequenced
table that NOSUTIL creates in the catalog where VALIDATE, REFRESH, or
INSTALL is being run. The log table also creates a mapping entry in the NonStop
ODBC master catalog. If a table that has the same name as output-filename
already exists, NOSUTIL appends the command response messages to the log
table.
Example
The following statement refreshes the NonStop SQL/MP catalog
\TEST.$VOL2.PERSNL:
usercat refresh \test.$vol2.persnl
USERCAT REFRESH verifies that all objects registered in the catalog are listed in the
mapping tables. Objects not listed are added to the mapping tables.
USERCAT REFRESH [ catalog-name [ LOG output-filename ] ]