ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-8
Listing the Mapped Object Names
The NonStop ODBC Server assigns simple names as shown in Example 7-1 only if the
tables are not partitioned. If a table is partitioned, new names are not assigned.
Instead, the NonStop ODBC Server chooses one partition per object to map in
ZNUOBJ. Even if primary and secondary partitions of the same object are registered in
different catalogs, ZNUOBJ has only one entry for the object. NonStop ODBC Server
determines which partition to map as follows:
•
If the primary partition is local, the primary partition is the mapped object.
•
If the primary partition is not local, the first partitioned object in the list of objects in
the catalog (TABLES, INDEXES) is the mapped object.
•
If the object has no local partitions, the primary partition is the mapped object.
When you need to access the object by using the NonStop ODBC Server, use the
ODBC or SQL Server name given during USERCAT INSTALL or USERCAT
REFRESH. You can change the names by executing mapping table statements that
modify the NonStop ODBC Server mapping table ZNUOBJ. The following subsections
describe how to change the names.
Listing the Mapped Object Names
You can list the mapped names by selecting from the NonStop ODBC Server object
mapping table ZNUOBJ, where the mapped names are registered.
Table 7-2 lists and describes the columns in ZNUOBJ.
Table 7-2. Description of ZNUOBJ (page 1 of 2)
Column Name Data Type Description
T_UID UNSIGNED INT (2) The numeric user ID of the owner.
T_OBJNAME VARCHAR (60) The ODBC/SQL Server object name in
uppercase letters.
T_UNAME VARCHAR (60) The owner name in uppercase letters.
T_OBJTYPE CHAR (2) A code indicating the object type:
N NonStop SQL/MP catalog table or
NonStop ODBC Server mapping table
S System table view
T Temporary table
U User table
VView
T_OBJID INT(4) An object ID used internally by the
NonStop ODBC Server.
N_OBJNAME CHAR (34) The fully qualified NonStop SQL/MP
object name in uppercase letters.