ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-24
NonStop ODBC Server Catalogs
NonStop ODBC Server Catalog Schema
The following are the tables in a NonStop ODBC Server user catalog:
These tables are used by the NonStop ODBC server to map table, view, index, and
stored procedure names. The ZNUPCOL describes the parameters of the stored
procedures.
The NonStop ODBC Server system catalog serves as a NonStop ODBC Server user
catalog and has several other uses: it maps items that are constant over the user
catalogs: database names, data types, error messages, logical usernames, and alias-
to-logical relationships. It holds configuration information for usernames. Finally, it
holds some special information needed to support the DBLIB catalogs
SYSPROTECTS and SYSVALUES.
The following are the tables in a NonStop ODBC Server system catalog:
Table Usage
ZNUDT Map data types
ZNUIX Map index names
ZNUMTRX Log resource accounting data
ZNUOBJ Map table and view names
ZNUPCOL Map stored procedure column names
ZNUPROC Map stored procedure names
ZNUQST Log query status data
ZNUTRA* Log trace data
* Template only; user can define actual table name.
Table Usage
ZNSALT Configure alias usernames
ZNSCON Configure CONTROL statement attributes
ZNSDB Map database names
ZNSDEF Configure DEFINE attributes
ZNSGOV Configure resource governing policies
ZNSMSG Map error messages
ZNSNET Configure network service attributes
ZNSPROF Configure profiles
ZNSPROT Help support SYSPROTECTS for TSQL
ZNSSCFG Configure system attributes
ZNSSCS Configure SCS
ZNSSER Configure server class
ZNSSMAP Map SCS to server class
ZNSTRA Configure trace information