ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-42
ZNUDT (For Data Types Mapping)
ZNUDT (For Data Types Mapping)
The static table ZNUDT maps ODBC or SQL Server data types to NonStop SQL/MP
data types and vice versa. ZNUDT, TABLES, COLUMNS, and ZNUOBJ are joined to
form the view ZVUCOL, which corresponds to the system table SYSCOLUMNS.
ZNUDT is used only for this purpose.
ZNUDT is loaded during SYSCAT INSTALL or USERCAT INSTALL. It describes the
mapping between NonStop SQL and the SQL Server API and the ODBC API. It
corresponds to the TDS encoding/decoding routines in the NonStop ODBC Server. It is
used in the view that generates the result set for the DBLIB API, SYSCOLUMNS, or
the ODBC CLI function SQLColumns.
ZNUDT resides in each user catalog.
See also SYSTYPES Catalog View (ZVUDT) on page 8-70 and SQLColumns
Procedure (ZVUOCOL) on page 8-60.
Table 8-21. Description of ZNUDT (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
N_DTYPE
x–
CHAR (18) NonStop SQL/MP data type code
to join with the COLUMNS table.
N_PRECLO
x–
INT (2) Low end of the precision range (0
if not applicable).
N_PRECHI
x–
INT (2) UNSIGNED High end of the precision range (0
if not applicable).
N_SCALELO
x–
INT (2) Low end of the scale range (0 if
not applicable).
N_SCALEHI
x–
INT (2) High end of the scale range (0 if
not applicable).
T_DTYPE
––
INT (2) ODBC or SQL Server data type
code.
T_USERTYPE
––
INT (2) ODBC or SQL Server user-
defined data type code.
T_ODBCTYPE
––
INT (2) ODBC user-defined data type
code.
T_NAME
x–
VARCHAR (30) ODBC or SQL Server data type
name, such as INT, FLOAT, or
DATETIME.
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