ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-51
ZNUOBJ (For Logical Object Names Mapping)
ZNUOBJ (For Logical Object Names Mapping)
The table ZNUOBJ maps ODBC or SQL Server table and view names to NonStop
SQL/MP object names.
ZNUOBJ resides in both the subvolume of the system catalog and a customized user
catalog.
Table 8-24. Description of ZNUOBJ (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
T_UID
x–
INT (2) UNSIGNED Numeric user ID of the owner.
T_OBJNAME
xx
VARCHAR (60) Fully qualified ODBC or SQL
Server object name in uppercase
letters.
T_UNAME
–x
VARCHAR (60) Logical username in uppercase
letters.
T_OBJTYPE
––
CHAR (2) Code indicating the object type:
N NonStop SQL/MP catalog
table or NonStop ODBC
Server mapping table
S System table view
T Temporary table
UUser table
VView
T_OBJID
–x
INT (4) Object ID used internally by the
NonStop ODBC Server to satisfy
requirements of TSQL users.
N_OBJNAME
–x
CHAR (34) Fully qualified NonStop SQL/MP
object name in uppercase letters.
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