SQL$HELP_OLD72.HLB  —  DECLARE  Extended Dynamic CURSOR, Format
  DECLARE <cursor-name-parameter> ---------------+
  +----------------------------------------------+
  ++---+----------------+-> TABLE CURSOR -+----------------++
   |   +-> INSERT ONLY -+                 +-> with-clause -+|
   |   +-> READ ONLY ---+                                   |
   |   +-> UPDATE ONLY -+                                   |
   | +------------------------------------------------------+
   | +--> FOR ---> <statement-id-parameter> ------------+------->
   +-+--------------++----------++-> LIST CURSOR FOR -+ |
     +-> READ ONLY -++> SCROLL -+|                    | |
     +-> INSERT ONLY ------------+                    | |
   +--------------------------------------------------+ |
   +-> <statement-id-parameter> ------------------------+

  with-clause =

  ---> WITH --> HOLD -+-------------------------------+->
                      +-> PRESERVE --+-> ON COMMIT ---+
                                     +-> ON ROLLBACK -+
                                     +-> ALL ---------+
                                     +-> NONE --------+
Close Help