Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  UPDATE  Format
  UPDATE -+-> <table-name> -+-+---------------------+-+
          +-> <view-name> --+ +> <correlation-name> + |
    +-------------------------------------------------+
    +-> SET -+> <column-name> = -+-> value-expr -+-+-+
             |                   +-> NULL -------+ | |
             |                   +-> DEFAULT ----+ | |
             +--------------- , <------------------+ |
    +------------------------- <---------------------+
    ++--------------------------------------------------------+-+
     +-> WHERE -+-> predicate -+---------------------------+-++ |
                |              +> optimize-clause ---------+ |  |
                +-> CURRENT OF <cursor-name> ----------------+  |
    +------------------------- <--------------------------------+
    ++----------------------+------------------------------------>
     +-> returning-clause --+

  optimize-clause =

  --+---------------------------------------------------------------+--->
    +-> OPTIMIZE --+-+-> FOR -+-> FAST FIRST --------+----------+-+-+
                   | |        +-> TOTAL TIME --------+          | |
                   | |        +-> SEQUENTIAL ACCESS -+          | |
                   | +-> USING <outline-name> ------------------+ |
                   | +-> WITH -+-> DEFAULT  --+-> SELECTIVITY  -+ |
                   | |         +-> SAMPLED  --+                 | |
                   | |         +-> AGGRESSIVE +                 | |
                   | +-> AS <query-name> -----------------------+ |
                   +---------------- <----------------------------+

  returning-clause=

  --+------------------------------+-+-------------------------+->
    +-> RETURNING +-> value-expr +-+ +-> INTO +> <parameter> +-+
                  +------ , <----+            +------ , <----+
Close Help