ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-44
ZNUIX (For Logical Index Names to Guardian
Names Mapping)
ZNUIX (For Logical Index Names to Guardian Names Mapping)
The table ZNUIX maps ODBC or SQL Server index names to NonStop SQL/MP index
names. This mapping is needed because ODBC or SQL Server index names are
bound to their table names and need not be unique, whereas NonStop SQL/MP index
names must be unique.
ZNUIX resides in both the subvolume of the system catalog and a customized user
catalog.
The index ZNUIXI1 ensures that any NonStop SQL/MP index name in ZNUIX is
unique. The index is created on the N_INAME column of ZNUIX.
ZNUIXI1 resides in both the subvolume of the system catalog and a customized user
catalog.
Table 8-22. Description of ZNUIX
Column Name
Primary Key Unique Index
Data Type Description
T_INAME
x–
CHAR (60) Fully qualified index name in
uppercase letters.
T_TABLEID
x–
INT (4) Object ID (T_OBJID in ZNUOBJ)
of the table.
T_STATUS
––
INT (2) Used internally by the NonStop
ODBC Server to record whether
an index is unique.
N_INAME
–x
CHAR (34) Fully qualified NonStop SQL/MP
index 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