ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-53
ZNUPCOL (For Stored Procedure Parameters and
Results)
ZNUPCOL (For Stored Procedure Parameters and Results)
The table ZNUPCOL contains information about the parameters and result sets of
stored procedures. The table contains one row for each input parameter, each
input/output parameter, and, optionally, each column in the result set. ZNUPCOL also
provides support for the ODBC catalog function SQLProcedureColumns.
ZNUPCOL resides in both the subvolume of the system catalog and a customized user
catalog.
See also ZNUPROC (For Stored Procedure Attributes) on page 8-55.
Table 8-25. Description of ZNUPCOL (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
T_OBJID
xx
INT (4) Object ID used internally by the
NonStop ODBC Server to satisfy
requirements of TSQL users.
T_NAME
x–
VARCHAR (60) Column/parameter name.
T_SEQ
–x
INT (2) Sequence of the column.
T_TYPE
––
INT (2) Column type indicator:
1 SQL_PARAM_INPUT.
2 SQL_PARAM_INPUT_
OUTPUT.
N_DTYPE
––
CHAR (18) NonStop SQL/MP data type
name.
N_FSTYPE
––
INT (2) File-system SQL data type.
N_PREC
––
INT (2) Precision of the column data.
N_LEN
––
INT (2) Length of the column data.
N_SCALE
––
INT (2) Scale factor of the column data.
N_RADIX
––
INT (2) Radix of the column data (2 or
10).
T_NULLABLE
––
INT (2) Transact-SQL nullable indicator:
0 Not nullable
1Nullable
N_NULLABLE
––
CHAR (1) Nullable indicator:
Y Column is nullable.
N Column is not nullable.
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