ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-18
Customizing Catalogs
reported as file-system errors 48 and 49. It is possible to set the security access list on
base tables so that even a privileged user might not be able to complete a
configuration statement.
Customizing Catalogs
The SYSCAT INSTALL and USERCAT INSTALL statements customize the system
catalog and user catalogs, respectively
SYSCAT INSTALL Statement
The SYSCAT INSTALL statement customizes a NonStop SQL/MP system catalog at
the location specified by the =_NSODBC_SYSTEM_CATALOG DEFINE. If this
DEFINE is not present, SYSCAT INSTALL customizes the NonStop SQL/MP system
catalog.
You can execute SYSCAT INSTALL only from a TACL prompt (not as a pass-through
command), and you must be a privileged user.
SYSCAT INSTALL has the following syntax:
security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for the system catalog. For more information
about security for NonStop SQL/MP objects, see the “Security” entry in the
NonStop SQL/MP Reference Manual.
output-filename
specifies the NonStop SQL/MP table name of the log table where command status
messages are written. The log table is an unaudited, entry sequenced table that
NOSUTIL creates and registers in the same subvolume as the NonStop SQL/MP
system catalog. NOSUTIL does not create a mapping entry for the log table,
because the NonStop SQL/MP system catalog is not necessarily customized by
NonStop ODBC.
If the table already exists, NOSUTIL returns an error and SYSCAT INSTALL
terminates. If you omit this option, NOSUTIL returns all status messages to the
home terminal.
SYSCAT INSTALL [ SECURE security-string ]
[ LOG output-filename ]