Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                         .-ASENSITIVE-------------.
>>-DECLARE--cursor-name--+------------------------+------------->
                         +-INSENSITIVE------------+
                         |            .-DYNAMIC-. |
                         '-SENSITIVE--+---------+-'
 
   .-NO SCROLL-.
>--+-----------+------------------------------------------------>
   '-SCROLL----'
 
           .-WITHOUT HOLD-.  .-WITHOUT RETURN-------------. (1)
>--CURSOR--+--------------+--+----------------------------+------->
           '-WITH HOLD----'  |              .-TO CALLER-. |
                             '-WITH RETURN--+-----------+-'
                                            '-TO CLIENT-'
 
>--FOR--+-select-statement-+-----------------------------------><
        '-statement-name---'
 
Notes:
  1. The HOLD and RETURN clauses can be specified in any order.