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
|
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)
|
No comments:
Post a Comment