Saturday, 24 August 2013

DB2 Data Types for GET DIAGNOSTICS Items Returning Condition Information


The data types for GET DIAGNOSTICS items that return condition information.
Item
Description
Data Type
CATALOG_NAME
Contains the server name of the table that owns a constraint that caused an error or that caused an access rule or check violation.
VARCHAR(128)
CONDITION_NUMBER
Contains the number of the condition.
INTEGER
CURSOR_NAME
Contains the name of a cursor in an invalid cursor state.
VARCHAR(128)
DB2_ERROR_CODE1
Contains an internal error code.
INTEGER
DB2_ERROR_CODE2
Contains an internal error code.
INTEGER
DB2_ERROR_CODE3
Contains an internal error code.
INTEGER
DB2_ERROR_CODE4
Contains an internal error code.
INTEGER
DB2_INTERNAL_ERROR_POINTER
For some errors, contains a negative value that is an internal error pointer.
INTEGER
DB2_MESSAGE_ID
Contains the message ID that corresponds to the message contained in the CHAR(10)MESSAGE_TEXT diagnostic item.
INTEGER
DB2_MODULE_DETECTINGERROR
After any SQL statement, indicates which module detected the error.
CHAR(8)
DB2_ORDINAL_TOKEN_n
After any SQL statement, contains the nth token, where n is a value from 1 to 100.
VARCHAR(515)
DB2_REASON_CODE
After any SQL statement, contains the reason code for errors that have a reason-code token in the message text.
INTEGER
DB2_RETURNED_SQLCODE
After any SQL statement, contains the SQLCODE for the condition.
INTEGER
DB2_ROW_NUMBER
After any SQL statement that involves multiple rows, contains the row number on which DB2 detected the condition.
DECIMAL (31,0)
DB2_TOKEN_COUNT
After any SQL statement, contains the number of tokens available for the condition.
INTEGER
MESSAGE_TEXT
After any SQL statement, contains the message text associated with the SQLCODE.
VARCHAR (32672)
RETURNED_SQLSTATE
After any SQL statement, contains the SQLSTATE for the condition.
CHAR(5)
SERVER_NAME
After a CONNECT, DISCONNECT, or SET CONNECTION statement, contains the name of the server specified in the statement.
VARCHAR(128)


Created with Artisteer

No comments:

Post a comment