ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-9
Listing the Mapped Object Names
For details about ZNUOBJ and the other mapping tables, see Database and Object
Mapping on page 8-8.
To list the ODBC/SQL Server and NonStop SQL/MP object names, select the columns
T_OBJNAME and N_OBJNAME from ZNUOBJ, as shown in Example 7-2.
N_OBJTYPE CHAR (2) The NonStop SQL/MP object type:
TA Table
VI View
N_ORIGIN CHAR (1) A code indicating the type of statement
that created the object:
T Transact-SQL or CORE SQL
N NonStop SQL/MP
N_SESSIONID LARGEINT A session ID used internally by the
NonStop ODBC Server.
Table 7-2. Description of ZNUOBJ (page 2 of 2)
Column Name Data Type Description