.-CURRENT-. >>-+--------+--GET--+---------+--DIAGNOSTICS--+-statement-information-+->< '-label:-' '-STACKED-' +-condition-information-+ '-combined-information--' statement-information: .-,---------------------------------------------------------. V | |----+-SQL-variable-name-1--+-- = --statement-information-item-+--| '-SQL-parameter-name-1-' condition-information: |--CONDITION--+-+-SQL-variable-name-2--+-+----------------------> | '-SQL-parameter-name-2-' | '-integer------------------' .-,--------------------------------------------------------------. V | >----+-SQL-variable-name-3--+-- = --+-connection-information-item-+-+--| '-SQL-parameter-name-3-' '-condition-information-item--' combined-information: |--+-SQL-variable-name-4--+-- = --------------------------------> '-SQL-parameter-name-4-' (1) >--ALL--+------------------------------------------------------+-------| | .-,------------------------------------------------. | | V | | '---+-STATEMENT------------------------------------+-+-' '-+-CONDITION--+--+--------------------------+-' '-CONNECTION-' +-+-SQL-variable-name-5--+-+ | '-SQL-parameter-name-5-' | '-integer------------------'
statement-information-item: |--+-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_AUTHID_TRUNCATION-----+ +-DB2_AUTHORIZATION_ID------+ +-DB2_CONNECTION_METHOD-----+ +-DB2_CONNECTION_NUMBER-----+ +-DB2_CONNECTION_STATE------+ +-DB2_CONNECTION_STATUS-----+ +-DB2_CONNECTION_TYPE-------+ +-DB2_DDM_SERVER_CLASS_NAME-+ +-DB2_DYN_QUERY_MGMT--------+ +-DB2_ENCRYPTION_TYPE-------+ +-DB2_EXPANSION_FACTOR_FROM-+ +-DB2_EXPANSION_FACTOR_TO---+ +-DB2_PRODUCT_ID------------+ +-DB2_SERVER_CLASS_NAME-----+ +-DB2_SERVER_NAME-----------+ '-DB2_USER_ID---------------'
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.