ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-12
ZNSCON (For Control Statements)
ZNSCON (For Control Statements)
The ZNSCON table describes the NonStop SQL CONTROL directives that must be
executed by the process at initialization or reinitialization time. For the syntax of
NonStop SQL/MP CONTROL directives, see the NonStop SQL/MP Reference Manual.
ZNSCON is created during INSTALL, REFRESH, and UPGRADE operations. The
table may not contain any rows. Its structure is supported to eliminate a future catalog
version change.
ZNSCON resides only in the subvolume of the system catalog.
Table 8-6. Description of ZNSCON
Column Name
Primary Key Unique Index
Data Type Description
CON_NAME
––
VARCHAR (60) Lookup key relating one or more
CONTROL option(s) to a user
profile.
CON_SEQ
––
INT (2) Type of CONTROL directive; can
be one of the following:
0 refers to the executor
1 refers to a query
2–n refers to a table
(numbered
in order of table creation)
CON_TEXT
––
VARCHAR (3900) NonStop SQL/MP CONTROL
directive.
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