ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-61
SQLProcedureColumns Procedure (ZVUPCOL)
SQLProcedureColumns Procedure (ZVUPCOL)
The view ZVUPCOL satisfies the SQLProcedureColumns query for ODBC access. It
translates the parameter information into the NonStop ODBC Server parameter
description form.
ZVUPCOL resides in both the subvolume of the system catalog and a customized user
catalog.
See also the following:
•
ZNUDT (For Data Types Mapping) on page 8-42
•
ZNUOBJ (For Logical Object Names Mapping) on page 8-51,
•
ZNUPCOL (For Stored Procedure Parameters and Results) on page 8-53
•
SQLColumns on page 7-122.
Table 8-30. Description of ZVUPCOL
Column Name
Column Name in ZNUDT,
ZNUOBJ, or ZNUPCOL Description
T_UNAME ZNUOBJ.T_UNAME Fully qualified owner name in
uppercase letters.
T_OBJNAME ZNUOBJ.T_OBJNAME Fully qualified ODBC or SQL Server
object name in uppercase letters.
COLUMN_NAME ZNUPCOL.T_NAME Column/parameter name.
COLUMN_TYPE ZNUPCOL.T_TYPE Column type indicator:
1 SQL_PARAM_INPUT
2 SQL_PARAM_INPUT_OUTPUT
DATA_TYPE ZNUDT.T_ODBCTYPE ODBC user-defined data type code.
TYPE_NAME ZNUDT.T_NAME ODBC or SQL Server data type
name, such as INT, FLOAT, or
DATETIME.
PRECISION ZNUPCOL.N_PREC Degree of precision of this column
(type-dependent; numeric or datetime
only).
LENGTH ZNUPCOL.N_LEN Length of the column data.
SCALE ZNUPCOL.N_SCALE Scale factor of this column (type-
dependent; numeric datetime only).
RADIX ZNUPCOL.N_RADIX Radix of the column data (2 or 10).
T_NULLABLE ZNUPCOL.T_NULLABLE Indicates whether the ODBC or SQL
Server data type allows null values.