.-CURRENT-. >>-GET--+---------+--DIAGNOSTICS--+-statement-information-+---->< '-STACKED-' +-condition-information-+ '-combined-information--' statement-information: .-,-------------------------------------------. V | |--+---variable-1-- = --statement-information-item-+--+---------| '-variable-1-- = --DB2_GET_DIAGNOSTICS_DIAGNOSTICS-' condition-information: |--CONDITION--+-variable-2-+------------------------------------> '-integer----' .-,------------------------------------------------. V | >----variable-3-- = --+-connection-information-item-+-+---------| '-condition-information-item--' combined-information: |--variable-4-- = ----------------------------------------------> (1) >--ALL--+----------------------------------------+--------------| | .-,----------------------------------. | | V | | '---+-STATEMENT----------------------+-+-' '-+-CONDITION--+--+------------+-' '-CONNECTION-' +-variable-5-+ '-integer----'
statement-information-item: |--+-COMMAND_FUNCTION----------------+--------------------------| +-COMMAND_FUNCTION_CODE-----------+ +-DB2_DIAGNOSTIC_CONVERSION_ERROR-+ +-DB2_LAST_ROW--------------------+ +-DB2_NUMBER_CONNECTIONS----------+ +-DB2_NUMBER_PARAMETER_MARKERS----+ +-DB2_NUMBER_RESULT_SETS----------+ +-DB2_NUMBER_ROWS-----------------+ +-DB2_NUMBER_SUCCESSFUL_SUBSTMTS--+ +-DB2_RELATIVE_COST_ESTIMATE------+ +-DB2_RETURN_STATUS---------------+ +-DB2_ROW_COUNT_SECONDARY---------+ +-DB2_ROW_LENGTH------------------+ +-DB2_SQL_ATTR_CONCURRENCY--------+ +-DB2_SQL_ATTR_CURSOR_CAPABILITY--+ +-DB2_SQL_ATTR_CURSOR_HOLD--------+ +-DB2_SQL_ATTR_CURSOR_ROWSET------+ +-DB2_SQL_ATTR_CURSOR_SCROLLABLE--+ +-DB2_SQL_ATTR_CURSOR_SENSITIVITY-+ +-DB2_SQL_ATTR_CURSOR_TYPE--------+ +-DYNAMIC_FUNCTION----------------+ +-DYNAMIC_FUNCTION_CODE-----------+ +-MORE----------------------------+ +-NUMBER--------------------------+ +-ROW_COUNT-----------------------+ +-TRANSACTION_ACTIVE--------------+ +-TRANSACTIONS_COMMITTED----------+ '-TRANSACTIONS_ROLLED_BACK--------' connection-information-item: |--+-CONNECTION_NAME---------+----------------------------------| +-DB2_AUTHENTICATION_TYPE-+ +-DB2_AUTHORIZATION_ID----+ +-DB2_CONNECTION_METHOD---+ +-DB2_CONNECTION_NUMBER---+ +-DB2_CONNECTION_STATE----+ +-DB2_CONNECTION_STATUS---+ +-DB2_CONNECTION_TYPE-----+ +-DB2_DYN_QUERY_MGMT------+ +-DB2_ENCRYPTION_TYPE-----+ +-DB2_PRODUCT_ID----------+ +-DB2_SERVER_CLASS_NAME---+ '-DB2_SERVER_NAME---------'
condition-information-item: |--+-CATALOG_NAME------------------+----------------------------| +-CLASS_ORIGIN------------------+ +-COLUMN_NAME-------------------+ +-CONDITION_IDENTIFIER----------+ +-CONDITION_NUMBER--------------+ +-CONSTRAINT_CATALOG------------+ +-CONSTRAINT_NAME---------------+ +-CONSTRAINT_SCHEMA-------------+ +-CURSOR_NAME-------------------+ +-DB2_ERROR_CODE1---------------+ +-DB2_ERROR_CODE2---------------+ +-DB2_ERROR_CODE3---------------+ +-DB2_ERROR_CODE4---------------+ +-DB2_INTERNAL_ERROR_POINTER----+ +-DB2_LINE_NUMBER---------------+ +-DB2_MESSAGE_ID----------------+ +-DB2_MESSAGE_ID1---------------+ +-DB2_MESSAGE_ID2---------------+ +-DB2_MESSAGE_KEY---------------+ +-DB2_MODULE_DETECTING_ERROR----+ +-DB2_NUMBER_FAILING_STATEMENTS-+ +-DB2_OFFSET--------------------+ +-DB2_ORDINAL_TOKEN_n-----------+ +-DB2_PARTITION_NUMBER----------+ +-DB2_REASON_CODE---------------+ +-DB2_RETURNED_SQLCODE----------+ +-DB2_ROW_NUMBER----------------+ +-DB2_SQLERRD_SET---------------+ +-DB2_SQLERRD1------------------+ +-DB2_SQLERRD2------------------+ +-DB2_SQLERRD3------------------+ +-DB2_SQLERRD4------------------+ +-DB2_SQLERRD5------------------+ +-DB2_SQLERRD6------------------+ +-DB2_TOKEN_COUNT---------------+ +-DB2_TOKEN_STRING--------------+ +-MESSAGE_LENGTH----------------+ +-MESSAGE_OCTET_LENGTH----------+ +-MESSAGE_TEXT------------------+ +-PARAMETER_MODE----------------+ +-PARAMETER_NAME----------------+ +-PARAMETER_ORDINAL_POSITION----+ +-RETURNED_SQLSTATE-------------+ +-ROUTINE_CATALOG---------------+ +-ROUTINE_NAME------------------+ +-ROUTINE_SCHEMA----------------+ +-SCHEMA_NAME-------------------+ +-SERVER_NAME-------------------+ +-SPECIFIC_NAME-----------------+ +-SUBCLASS_ORIGIN---------------+ +-TABLE_NAME--------------------+ +-TRIGGER_CATALOG---------------+ +-TRIGGER_NAME------------------+ '-TRIGGER_SCHEMA----------------'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.