ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-21
USERCAT INSTALL Statement
EMPTY
installs the user catalog and populates the mapping tables without installing the
entries for the user-created NonStop SQL/MP objects in the current catalog.
Example
The following statement customizes the NonStop SQL/MP catalog named
\TEST.$VOL2.PERSNL:
USERCAT INSTALL \test.$vol2.persnl
Effects of USERCAT INSTALL
USERCAT INSTALL does the following:
•
Creates the following objects in your subvolume:
These objects are the NonStop ODBC Server mapping tables. Do not purge these
objects; they contain the mapping information for your catalog. For a description of
the objects, see Section 8, HP NonStop ODBC Server Mapping Tables.
•
If the catalog is a NonStop SQL/MP catalog not customized for the NonStop ODBC
Server, populates the mapping tables with one entry for each NonStop SQL/MP
object in the current catalog.
•
If the EMPTY option is specified while installing the catalog, does not populate the
ZNUOBJ or ZNUIX system tables for user-created NonStop SQL/MP objects.
•
To indicate that it is customized, adds your catalog to SYSDATABASES, and adds
a row to ZNSDB for the catalog and database.
•
If the owner of catalog-name has no corresponding entry in ZNSUS, creates an
entry. The logical username in this entry is the default value for the current group
and user. No values for profile, server class, or trace are generated.
•
If you are not authorized to create an SQL catalog in the specified subvolume, or if
you are not authorized to write to the underlying NonStop SQL/MP catalog,
generates an error.
•
If you are not authorized to write to ZNSDB, generates an error.
•
If the catalog is already customized for an earlier version of the NonStop ODBC
Server, generates an error. You must then either deinstall the catalog and reinstall,
or upgrade it to the latest version.
ZNUDT ZNUOBJI1 ZNUPCOL ZVUIX ZVUPROT
ZNUIX ZNUOBJI2 ZNUPROC ZVUOBJ ZVUUS
ZNUIXI1 ZNUOBJI3 ZVUCOL ZVUOCOL
ZNUOBJ ZNUPCLI1 ZVUDT ZVUPCOL