SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-57
Condition Items of GET DIAGNOSTICS
SERVER_NAME Character varying, length>=128. Identifies server.
Reserved for future use.
CONNECTION_NAME Character varying, length>=128. Identifies connection.
Reserved for future use.
CONSTRAINT_CATALOG Character varying, length>=128. Identifies catalog of
schema containing constraint or assertion. Reserved for
future use.
CONSTRAINT_SCHEMA Character varying, length>=128. Identifies schema
containing constraint or assertion. Reserved for future
use.
CONSTRAINT_NAME Character varying, length>=128. Identifies constraint or
assertion. Returns a fully qualified name for SQLCODE
errors in the range -4000 through -4999 and in the
range -8000 through -8999.
CATALOG_NAME Character varying, length>=128. Identifies catalog of
table (referenced by failed assertion) modified by
statement execution. Reserved for future use.
SCHEMA_NAME Character varying, length>=128. Identifies schema of
table (referenced by failed assertion) modified by
statement execution. Reserved for future use.
TABLE_NAME Character varying, length>=128. Identifies table
(referenced by failed assertion) modified by statement
execution. Returns a fully qualified table name for
SQLCODE errors in the range -4000 through -4999.
COLUMN_NAME Character varying, length>=128. Identifies inaccessible
column due to access rule violation. Returns a column
name for SQLCODE errors in the range -4000 through
-4999.
CURSOR_NAME Character varying, length>=128. Identifies cursor in
invalid state. Reserved for future use.
MESSAGE_TEXT Character varying, length>=128. Explanatory text.
MESSAGE_LENGTH Exact numeric, scale 0. Character length of
MESSAGE_TEXT.
MESSAGE_OCTET_LENGTH Exact numeric, scale 0. Octet length of
MESSAGE_TEXT.
NSK_CODE Exact numeric, scale 0. NSK code value of the
condition.
SQLCODE* Exact numeric, scale 0. SQLCODE value of this
condition.
* The condition item is an SQL/MX extension.
Table 3-4. GET DIAGNOSTICS Condition Items (page 2 of 2)
Condition Item Name Data Type and Description