ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-14
ZNSDEF (For NonStop ODBC Server DEFINEs)
ZNSDEF (For NonStop ODBC Server DEFINEs)
The table ZNSDEF stores the names of the NonStop ODBC Server DEFINEs and
values to be set prior to process initiation. ZNSDEF stores only attribute settings
defined by the NonStop Kernel (as opposed to the ZNSSCFG table, which stores
attribute settings defined by the ODBC server).
No values are loaded into ZNSDEF during system installation. The user is thereby able
to establish DEFINE values to be used by the SQL executor and other collaborating
processes. The NonStop ODBC server currently does not use DEFINEs as a means of
setting run-time values.
ZNSDEF resides only in the subvolume of the system catalog.
Table 8-8. Description of ZNSDEF
Column Name
Primary Key Unique Index
Data Type Description
SCS_NAME
x_
CHAR(16) Process identity key.
DEFINE_NAME
x–
CHAR (24) NonStop Kernel DEFINE name.
DEFINE_CLASS
–
CHAR (16) NonStop Kernel DEFINE class.
DEFINE_ATTRIBUTE
x–
CHAR (16) NonStop Kernel DEFINE attribute
name.
DEFINE_VALUE
–
VARCHAR (512) NonStop Kernel DEFINE attribute
value.
LAST_UPDATED
––
DATETIME YEAR
TO FRACTION (6)
Date and time this row was added
or last modified.
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