ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-18
ZNSMSG (For Error Messages)
ZNSMSG (For Error Messages)
The table ZNSMSG contains all error messages that can be generated by the NonStop
ODBC Server. The table maps a NonStop ODBC Server error code to its
corresponding ODBC or SQL Server error code (where possible). It also contains error
text and the ODBC or SQL Server severity level. For details on the error messages,
see the HP NonStop ODBC Server Messages Manual.
ZNSMSG is a static table created but not populated at system installation time. It is
loaded during the customization of catalogs (SYSCAT INSTALL). It serves TSQL
users, but not ODBC users.
ZNSMSG resides only in the subvolume of the system catalog.
See also SYSMESSAGES Catalog View (ZVSMSG) on page 8-66.
Table 8-10. Description of ZNSMSG (page1of2)
Column Name
Primary Key Unique Index
Data Type Description
N_PRODNUM
––
CHAR (5) NonStop ODBC Server product
number.
N_VERSION
––
CHAR (3) NonStop ODBC Server version
number.
N_ERROR_CODE
x–
INT (4) Error code generated by the
NonStop ODBC Server or
NonStop SQL/MP.
N_LANGUAGE
x–
INT (2) Not used.
N_SPECSYM
––
VARCHAR (4) Special symbol (~) used by the
error handler for error parameter
substitutions.
T_ERROR_CODE
––
INT (4) ODBC or SQL Server error code
that corresponds to this message.
If there is no corresponding ODBC
or SQL Server error code, the
code is 18001.
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