ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables

HP NonStop ODBC Server Reference Manual—429151-002

8-66

SYSMESSAGES Catalog View (ZVSMSG)

The catalog view SYSMESSAGES contains error codes and error text.

SYSMESSAGES is represented as a view over a mapping table. The view and

mapping table reside only in the subvolume of the system catalog.

Sequence of rows is ascending by ERROR.

SYSMESSAGES is created when the NonStop ODBC Server is installed. It is provided

for DLIB compatibility but is not used by the NonStop ODBC server or NOSUTIL

program for generating error messages.

SYSMESSAGES is retained for backward compliance with the old gateway, SQLSG,

and DLIB programs.

See also ZNSMSG (For Error Messages) on page 8-18.

Table 8-34. Description of SYSMESSAGES

Column Name

Attribute Name or Column

Name in ZNSMSG Description

ERROR T_ERROR_CODE 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.

SEVERITY ZNSMSG.T_CLASS THE ODBC or SQL Server error

severity level:

10 Warning

11–16 User-generated

17–18 Nonfatal error

19+ Fatal error

DLEVEL ZNSMSG.T_STATE ODBC or SQL Server error detail

level. Assigned –1.

DESCRIPTION ZNSMSG.N_ERROR_TEXT Error text. This is usually TSQL, but in

some cases, it is NonStop SQL/MP.