ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-52
ZNUOBJ (For Logical Object Names Mapping)
The index ZNUOBJI1 ensures that the user ID and server name combination is unique.
The index is created on the T_UNAME and T_OBJNAME columns of ZNUOBJ.
ZNUOBJI1 resides in both the subvolume of the system catalog and a customized user
catalog.
The index ZNUOBJI2 ensures that any NonStop SQL/MP object name in ZNUOBJ is
unique. The index is created on the N_OBJNAME column of ZNUOBJ. ZNUOBJI2
resides in both the subvolume of the system catalog and a customized user catalog.
The index ZNUOBJI3 is used internally by the NonStop ODBC Server. The index is
created on the T_OBJID column of ZNUOBJ. ZNUOBJI3 resides in both the
subvolume of the system catalog and a customized user catalog.
The resource accounting log files ZNUMTRX, ZNUQST, and the default tracelog
ZNUTRA, are considered user-tables and therefore have a T_OBJTYPE of “U”.
N_OBJTYPE
––
CHAR (2) NonStop SQL/MP object type:
TA Table
VI View
N_ORIGIN
––
CHAR (1) Code indicating the type of
statement that created the object:
T Transact-SQL or
CORE SQL
N NonStop SQL/MP
N_SESSIONID
––
INT (8) Session ID used internally by the
NonStop ODBC Server.
Table 8-24. Description of ZNUOBJ (page 2 of 2)
Column Name
Primary Key Unique Index
Data Type Description
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index