Syntax

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