ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-54
ZNUPCOL (For Stored Procedure Parameters and
Results)
The index ZNUPCLI1 ensures that any procedure parameter definition in ZNUPCOL is
unique for a given procedure. The index is created on the T_OBJID and T_SEQ
columns of ZNUPCOL.
ZNUPCLI1 resides in both the subvolume of the system catalog and a customized user
catalog.
N_
DATETIMESTARTFIELD
––
INT (2) Most significant field to be used in
stored DATETIME values:
1Year
2Month
3Day
4Hour
5Minute
6Second
7 Fraction
0 Not a DATETIME value
N_
DATETIMEENDFIELD
––
INT (2) Least significant field (1–7) to be
used in stored DATETIME values.
N_DEFAULTCLASS
––
CHAR (1) Default value class:
N No default
UDefault value
D Default null
N_DEFAULTVALUE
––
VARCHAR (254) The default value.
Table 8-25. Description of ZNUPCOL (page 2 of 2)
Column Name
Primary Key Unique Index
Data Type Description
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