Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram        .-SQL-.              .-LOCAL--.
>>-SET--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name---->
                             '-GLOBAL-'
 
     .-,---------------.
     V                 |
>--+---set-header-info-+----------------------------+----------><
   |                              .-,-------------. |
   |                              V               | |
   '-VALUE--+-integer----------+----set-item-info-+-'
            '-integer-variable-'
 
Read syntax diagramSkip visual syntax diagramset-header-info:
 
|--COUNT-- = --+-constant-1-+-----------------------------------|
               '-variable-1-'
 
set-item-info:
 
|--+-DATA----------------------+-- = --+-constant-2-+-----------|
   +-DATETIME_INTERVAL_CODE----+       '-variable-2-'
   +-DB2_CCSID-----------------+
   +-INDICATOR-----------------+
   +-LENGTH--------------------+
   +-LEVEL---------------------+
   +-PRECISION-----------------+
   +-SCALE---------------------+
   +-TYPE----------------------+
   +-USER_DEFINED_TYPE_CATALOG-+
   +-USER_DEFINED_TYPE_NAME----+
   '-USER_DEFINED_TYPE_SCHEMA--'