ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-30
ZNSSCFG (For System Configuration Values)
If the default value for the attribute on the ZNSSCFG table is “None,” the process
reports an error. If the process is SCS or NOS, the process stops. If the process is
NOSUTIL, the command fails.
For more information on default values, see Default Values for NonStop ODBC Server
Attributes on page 8-4. For a list of the system configuration default values at system
installation time, see Appendix D, Summary of System Installation Defaults.
You can update the LAST_UPDATE_SYSTEM_CONFIG value in two ways:
•
Execute an ADD, MODIFY, or REMOVE statement on any other configuration
component, using the optional parameter for updating the system configuration.
•
Execute a MODIFY statement on the LAST_UPDATE_SYSTEM_CONFIG row.
Recovering From SQL Errors
You can use items in the ZNSSCFG table to specify that the system take a particular
action when an SQL error or warning that you specify is encountered. To enable this
feature, add the COLLECT_SQL_ERROR_INFO attribute to the ZNSSCFG table and
set its value to Y (setting its value to N disables the feature), as follows:
ADD SCFG COLLECT_SQL_ERROR_INFO “Y”
Then add the SQL_ERROR_sqlcode or SQL_WARNING_sqlcode attribute, where
sqlcode is the error or warning code of interest, and specify an action code. To cause
NOS to abend when it encounters SQL error 8013, enter the following:
ADD SCFG SQL_ERROR_8013 “1” UPDATE_SYSTEM_CONFIG
To cause the system to create a SAVEABEND file when NOS abends, set the
NOS_DEBUG_OPTIONS attribute in the serverclass to 4. For example:
MODIFY SERVERCLASS serverclass-name NOS_DEBUG_OPTIONS 4
Table 8-14. Description of ZNSSCFG
Column Name
Primary Key Unique Index
Data Type Description
ITEM
x–
VARCHAR (60) Column or attribute name.
VALUE
––
VARCHAR (240) Default value for the column or
attribute.
LAST_UPDATED
––
DATETIME YEAR
TO FRACTION (6)
Last time this component of the
system configuration was
changed.
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