ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-62
SYSCOLUMNS Catalog View (ZVUCOL)
SYSCOLUMNS Catalog View (ZVUCOL)
The catalog view SYSCOLUMNS lists the columns of tables and views in a NonStop
SQL/MP catalog.
SYSCOLUMNS is represented by a join view over COLUMNS, TABLES, ZNSOBJ (the
object mapping table), and ZNUDT (the data types mapping table). The view and
mapping tables reside on each customized subvolume.
Sequence of rows is ascending by ID.
SYSCOLUMNS does not contain column definitions for the input, output, or result
columns of the stored procedures in ZNUPROC.
.
Table 8-31. Description of SYSCOLUMNS
Column Name
Column Name in ZNUIX,
COLUMNS, or SYSTYPES Description
ID ZNUIX.T_TABLEID Object ID used internally by the
NonStop ODBC Server.
NUMBER None No corresponding column name.
Assigned 0.
COLID COLUMNS.COLNUMBER A number indicating the position of
the column in the row of the table (the
first column is 0).
STATUS COLUMNS.NULLABLE A number indicating whether the
ODBC or SQL Server data type
allows null values.
TYPE COLUMNS.DATATYPE ODBC or SQL Server data type code.
LENGTH COLUMNS.COLSIZE Byte length of the data in the column.
OFFSET COLUMNS.OFFSET Reserved for internal use by HP
software.
USERTYPE SYSTYPES.USERTYPE. ODBC or SQL Server user-defined
data type code.
CDEFAULT None No corresponding column name.
Assigned –1.
DOMAIN None No corresponding column name.
Assigned –1.
NAME COLUMNS.COLNAME. “#”s
and “$”s are represented as
“_”s. Leading “_”s are
represented as “U”s.
Column name, which is a NonStop
SQL/MP identifier.
PRINTFMT None No corresponding column name.
Assigned “ ” (blank).