SQL$HELP_OLD72.HLB  —  INSERT  Format
  INSERT INTO -+-> <table-name> ----+-+---------------------------+-+-+
               +-> <view-name> -----+ +-> AS <correlation-name> --+ | |
               +->  CURSOR <cursor-name> ---------------------------+ |
  +-------------------------------------------------------------------+
  +---> DEFAULT VALUES ------------------+->-+---------------------+-+->
  +--------------------------------+---+ |   +-> returning-clause -+ |
  +---> ( -+> <column-name> +-> ) -+   | |                           |
           +-------- , <----+          | |                           |
  +---------------<--------------------+ |                           |
  +-> value-clause ----------------------+                           |
  +-> select-expr -+--------------------+--->------------------------+
                   +-> optimize-clause -+

  value-clause =

   ----> VALUES -> ( -++> <parameter> ----------++-> ) --->
                      |+> <qualified-parameter> +|
                      |+> value-expr -----------+|
                      |+> DEFAULT --------------+|
                      +------- , <---------------+

  returning-clause =

  -+----------------------------------------++-------------------+->
   +-> RETURNING value-expr ----------------++> INTO <parameter> +
   +-> PLACEMENT ONLY RETURNING -+-> DBKEY -+
                                 +-> ROWID -+

  value-expr =

  ---+--> numeric-value-expr -----+----->
     +--> char-value-expr --------+
     +--> date-time-value-expr ---+
     +--> interval-value-expr ----+
     +--> date-vms-value-expr ----+
     +--> DBKEY ------------------+
     +--> NULL -------------------+
     +--> ROWID ------------------+

  select-expr =

  -+-+->  select-clause  ------------+-+------+
   | +-> ( select-expr )  -----------+ |      |
   | +->   TABLE table-ref ----------+ |      |
   +------ select-merge-clause <-------+      |
     +------------------- <-------------------+
     +-+--------------------+--+------------------+--+--------------------+->
       +-> order-by-clause -+  +-> offset-clause -+  +-> limit-to-clause -+

  optimize-clause =

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

  select-merge-clause =

  -+-> EXCEPT -+--------------+---+----+-------------------+-->
   |           +-> DISTINCT --+   |    +-> CORRESPONDING --+
   +-> INTERSECT -+-------------+-+    +-> NATURAL --------+
   |              +-> DISTINCT -+ |
   +-> MINUS ---------------------+
   +-> UNION --+-------------+----+
               +-> ALL ------+
               +-> DISTINCT -+
Close Help