Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram        .-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----'
 
Notes:
  1. STATEMENT can only be specified once. If variable-5 or integer is not specified, CONDITION and CONNECTION can only be specified once.
Read syntax diagramSkip visual syntax diagramstatement-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---------'
 
Read syntax diagramSkip visual syntax diagramcondition-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----------------'