ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-20
USERCAT INSTALL Statement
USERCAT INSTALL Statement
The USERCAT INSTALL statement customizes a NonStop SQL/MP user catalog. To
use the NonStop ODBC Server to access a catalog created with NonStop SQL/MP, you
must first customize the catalog.
USERCAT INSTALL has the following syntax:
catalog-name
is the name of the subvolume containing the NonStop SQL/MP catalog to
customize. The catalog-name is in Guardian format and can include the node
and volume. If you omit catalog-name, the default node, volume, and subvolume
for the current user is used.
If the specified subvolume already contains a customized catalog, an error
message is generated and the statement does not execute.
If the specified subvolume does not contain a catalog, USERCAT INSTALL creates
a new catalog and customizes it.
security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for the user catalog. For more information
about security for NonStop SQL/MP objects, see the “Security” entry in the
NonStop SQL/MP Reference Manual.
If you specify security-string, you must also explicitly specify
catalog-name. If you omit security-string, catalog security is set to the
default security for the current user profile, if defined. If default security is not
defined in the current profile, the default security is the system
DEFAULT_SECURITY value found in the ZNSSCFG mapping table.
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.
Note. If you create the catalog through the NonStop ODBC Server using the CREATE
DATABASE statement, you do not need to customize the catalog. For information about the
CREATE DATABASE statement, see Section 4, Transact-SQL Language.
USERCAT INSTALL [ [catalog-name ] [ SECURE security-string ]
[ LOG output-filename ] [EMPTY] ]