Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                                      .-FROM-.
>>-FETCH--+------------------------+--+------+--cursor-name----->
          +-NEXT-------------------+
          +-PRIOR------------------+
          +-FIRST------------------+
          +-LAST-------------------+
          |        (1)             |
          +-BEFORE-----------------+
          |       (2)              |
          +-AFTER------------------+
          +-CURRENT----------------+
          '-RELATIVE--+-variable-+-'
                      '-integer--'
 
>--+--------------------+--------------------------------------><
   +-single-fetch-------+
   '-multiple-row-fetch-'
 
single-fetch:
 
           .-,--------.
           V          |
|--+-INTO----variable-+-------------------------------------+---|
   |                        .-LOCAL--.                      |
   +-INTO--SQL--DESCRIPTOR--+--------+--SQL-descriptor-name-+
   |                        '-GLOBAL-'                      |
   '-INTO DESCRIPTOR--descriptor-name-----------------------'
 
multiple-row-fetch:
 
|--FOR--+-variable-+--ROWS-------------------------------------->
        '-integer--'
 
>--+-INTO--host-structure-array----------------------------------------------------------+--|
   |                           .-LOCAL--.                                                |
   '-+-USING--SQL--DESCRIPTOR--+--------+--SQL-descriptor-name-+--INTO--row-storage-area-'
     |                         '-GLOBAL-'                      |
     '-USING DESCRIPTOR--descriptor-name-----------------------'
 
row-storage-area:
 
|--:--host-identifier-1--+-------------------------------------+--|
                         | .-INDICATOR-.                       |
                         '-+-----------+--:--host-identifier-2-'
 
Notes:
  1. If BEFORE is specified, a single-fetch or multiple-row-fetch must not be specified.
  2. If AFTER is specified, a single-fetch or multiple-row-fetch must not be specified.