Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  DECLARE  Dynamic CURSOR, Format
  DECLARE <cursor-name> ----------------------+
  +-------------------------------------------+
  +-+-+----------------+-> TABLE CURSOR -+----------------+-+
    | +-> INSERT ONLY -+                 +-> with-clause -+ |
    | +-> READ ONLY ---+                                    |
    | +-> UPDATE ONLY -+                                    |
    | +-----------------------------------------------------+
    | +-> FOR -> <statement-name> ------------------------+-->
    ++--------------++----------++-> LIST CURSOR ------+  |
     +-> READ ONLY -++> SCROLL -+|                     |  |
     +-> INSERT ONLY ------------+                     |  |
     +-------------------------------------------------+  |
     +-> FOR -> <statement-name> -------------------------+

  with-clause =

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