ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-9
Database and Object Mapping
Table 8-4 lists the mapping tables that reside in both the subvolume of the customized
user catalogs and the subvolume of the NonStop SQL/MP system catalog.
ZNSUSI1 Index Ensures that the logical username is unique for this system.
ZNSUSI2 Index Ensures that the Guardian username is unique for all mappings
from logical to system usernames.
ZNSVALUE Table Used internally by the NonStop ODBC Server to support the
ODBC or SQL Server spt_values table.
Table 8-4. Mapping Tables Residing With Both the User Catalogs and the System
Catalog
File Name
Object
Type Description
ZNUDT Table Used for data type translation to and from NonStop SQL.
ZNUIX Table Maps logical index names to Guardian names.
ZNUIXI1 Index Ensures that any NonStop SQL/MP index name in ZNUIX is
unique.
ZNUMTRX Table Used as the log of resource accounting. Is the default simple file
name.
ZNUOBJ Table Maps ODBC or SQL Server table and view names to NonStop
SQL/MP table and view names, and maps procedure names to
NonStop ODBC Server procedure definitions in ZNUPROC.
ZNUOBJI1 Index Ensures that any ODBC or SQL Server object ID in ZNUOBJ is
unique.
ZNUOBJI2 Index Ensures that any NonStop SQL/MP object name in ZNUOBJ is
unique.
ZNUOBJI3 Index Used internally by the NonStop ODBC Server.
ZNUPCLI1 Index Ensures that any procedure parameter definition in ZNUPCOL is
unique for a given procedure.
ZNUPCOL Table Describes parameters of stored procedures. Also provides
support for ODBC catalog function SQLProcedureColumns.
ZNUPROC Table Associates stored procedure name with Pathway system and
server class. Also provides support for the SQL Server system
table SYSOBJECTS and the ODBC catalog function
SQLProcedures.
ZNUQST Table Used for logging of resource accounting. Is a simple file name.
ZNUTRA Table Logs trace event messages. (The name ZNUTRA is defined only
as a template. The actual name of the trace log can be any valid
user-supplied name.)
Table 8-3. Mapping Tables Residing Only With the System Catalog (page 2 of 2)
File Name
Object
Type Description