ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-70
SYSTYPES Catalog View (ZVUDT)
SYSTYPES Catalog View (ZVUDT)
The catalog view SYSTYPES contains each system-supplied data type. The NonStop
ODBC Server does not support user-defined data types.
SYSTYPES is represented by a view over a data type mapping table. The mapping
table resides on each customized subvolume. It contains the same constant values in
every catalog.
Table 8-37. Description of SYSTYPES
Column Name Column Name in ZNUDT Description
UID None No corresponding column name.
Assigned 1.
USERTYPE ZNUDT.T_USERTYPE ODBC or SQL Server user-defined
data type code.
VARIABLE None No corresponding column name.
Assigned –1.
ALLOWNULLS ZNUDT.T_NULLABLE Indicator regarding the use of nulls.
The value is based on the value in the
TYPE column:
0 TYPE is BIT, SYSNAME, or
TINYINT
1 TYPE is any other value
TYPE ZNUDT.T_DTYPE ODBC or SQL Server data type code.
LENGTH ZNUDT.N_PRECHI High end of the precision range. (0 if
not applicable).
TDEFAULT None No corresponding column name.
Assigned 0.
DOMAIN None No corresponding column name.
Assigned 0.
NAME ZNUDT.T_NAME ODBC or SQL Server data type
name, such as INT, FLOAT, or
DATETIME.
PRINTFMT None No corresponding column name.
Assigned “ ” (blank).