ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-19
SYSCAT INSTALL Statement
Example
The following statement customizes the NonStop SQL/MP system catalog in the
$SYSYEM.SQL subvolume.
ADD DEFINE =_NSODBC_SYSTEM_CATALOG, CLASS CATALOG, SUBVOL
$system.sql
SYSCAT INSTALL SECURE NUNU LOG log02
Effects of SYSCAT INSTALL
When you run SYSCAT INSTALL, the NonStop ODBC Server creates the following
objects in the subvolume of your system catalog:
These tables, indexes, and views are called the NonStop ODBC Server mapping
tables. Do not purge these objects; they are the mapping tables for your system. For a
description of the objects, see Section 8, HP NonStop ODBC Server Mapping Tables.
SYSCAT INSTALL also does the following:
•
Builds an SQL Server MASTER database representation with NonStop ODBC
Server extensions for the NonStop SQL/MP system catalog.
•
Inserts a new row into the ZNSDB mapping table to associate the logical database
name “MASTER” with the customized NonStop SQL/MP system catalog.
•
Runs under a separate TMF transaction. The NOSUTIL program automatically
commits the transaction after customizing the system catalog.
•
Generates an error if executed as a pass-through command.
•
Generates an error if the system catalog is already customized for the NonStop
ODBC Server.
•
Generates an error if you are not a privileged user.
If SYSCAT INSTALL fails for any reason, all updates to the system catalog are
automatically rolled back. If the system catalog was a valid NonStop SQL/MP system
catalog, it is still valid after roll back.
ZNSALT ZNSGOV ZNSTRA ZNUOBJI3 ZVUOBJ
ZNSALTI1 ZNSMSG ZNSUMAP ZNUPCLI1 ZVUOCOL
ZNSCON ZNSNET ZNSUS ZNUPCOL ZVUPCOL
ZNSCONI1 ZNSPROF ZNUDT ZNUPROC ZVUPROT
ZNSDB ZNSPROT ZNUIXI1 ZVSDB ZVUUS
ZNSDBI1 ZNSSCFG ZNUMTRX ZVSMSG
ZNSDBI2 ZNSSCS ZNUOBJ ZVUCOL
ZNSDEF ZNSSER ZNUOBJI1 ZVUDT
ZNSDUMMY ZNSSMAP ZNUOBJI2 ZVUIX