ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-13
ZNSDB (For NonStop ODBC Server Databases)
ZNSDB (For NonStop ODBC Server Databases)
The table ZNSDB maps ODBC or SQL Server database names to NonStop SQL/MP
catalog names. Each row in ZNSDB represents one NonStop ODBC Server
customized catalog. ZNSDB is populated by the INSTALL command.
ZNSDB resides only in the subvolume of the system catalog.
See also SYSDATABASES Catalog View (ZVSDB) on page 8-63.
The index ZNSDBI1 ensures that any database ID in ZNSDB is unique. The index is
created on the T_DBID column of ZNSDB. ZNSDBI1 resides only in the subvolume of
the system catalog.
The index ZNSDBI2 is created on the T_DBID column of ZNSDB. ZNSDBI2 resides
only in the subvolume of the system catalog.
Table 8-7. Description of ZNSDB
Column Name
Primary Key Unique Index
Data Type Description
N_CATALOG
x–
CHAR (25) Fully qualified NonStop SQL/MP
catalog name in uppercase letters.
T_DBNAME
–x
VARCHAR (60) Fully qualified ODBC or SQL
Server database name in
uppercase letters.
T_CREATOR
––
INT (2) UNSIGNED ODBC or SQL Server user ID of
the database creator. If the
database is created in NonStop
SQL/MP and then customized, the
creator is the user ID of the user
who customizes the catalog.
T_DBID
–x
INT (2) UNSIGNED Internal ID used by the NonStop
ODBC Server to satisfy
requirements of TSQL users.
T_VERSION
––
INT (2) NonStop ODBC Server version
number.
CREATETIME
––
INT (8) Date and time the catalog was
created.
LAST_UPDATED
––
DATETIME YEAR
TO FRACTION (6)
Date and time this row was added
or last modified.
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