Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram        .-SQL-.              .-LOCAL--.
>>-GET--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name---->
                             '-GLOBAL-'
 
     .-,---------------.
     V                 |
>--+---get-header-info-+----------------------------+----------><
   |                              .-,-------------. |
   |                              V               | |
   '-VALUE--+-integer----------+----get-item-info-+-'
            '-integer-variable-'
 
Read syntax diagramSkip visual syntax diagramget-header-info:
 
|--variable-1-- = --+-COUNT-----------------+-------------------|
                    +-DYNAMIC_FUNCTION------+
                    +-DYNAMIC_FUNCTION_CODE-+
                    +-KEY_TYPE--------------+
                    '-DB2_MAX_ITEMS---------'
 
get-item-info:
 
|--variable-2-- = --+-DATA-----------------------+--------------|
                    +-DATETIME_INTERVAL_CODE-----+
                    +-DB2_BASE_CATALOG_NAME------+
                    +-DB2_BASE_COLUMN_NAME-------+
                    +-DB2_BASE_SCHEMA_NAME-------+
                    +-DB2_BASE_TABLE_NAME--------+
                    +-DB2_CCSID------------------+
                    +-DB2_COLUMN_CATALOG_NAME----+
                    +-DB2_COLUMN_GENERATED-------+
                    +-DB2_COLUMN_GENERATION_TYPE-+
                    +-DB2_COLUMN_NAME------------+
                    +-DB2_COLUMN_SCHEMA_NAME-----+
                    +-DB2_COLUMN_TABLE_NAME------+
                    +-DB2_COLUMN_UPDATABILITY----+
                    +-DB2_CORRELATION_NAME-------+
                    +-DB2_LABEL------------------+
                    +-DB2_PARAMETER_NAME---------+
                    +-DB2_SYSTEM_COLUMN_NAME-----+
                    +-INDICATOR------------------+
                    +-KEY_MEMBER-----------------+
                    +-LENGTH---------------------+
                    +-LEVEL----------------------+
                    +-NAME-----------------------+
                    +-NULLABLE-------------------+
                    +-OCTET_LENGTH---------------+
                    +-PARAMETER_MODE-------------+
                    +-PARAMETER_ORDINAL_POSITION-+
                    +-PARAMETER_SPECIFIC_CATALOG-+
                    +-PARAMETER_SPECIFIC_NAME----+
                    +-PARAMETER_SPECIFIC_SCHEMA--+
                    +-PRECISION------------------+
                    +-RETURNED_LENGTH------------+
                    +-RETURNED_OCTET_LENGTH------+
                    +-SCALE----------------------+
                    +-TYPE-----------------------+
                    +-UNNAMED--------------------+
                    +-USER_DEFINED_TYPE_CATALOG--+
                    +-USER_DEFINED_TYPE_CODE-----+
                    +-USER_DEFINED_TYPE_NAME-----+
                    '-USER_DEFINED_TYPE_SCHEMA---'