Library /sys$common/syshlp/SQL$HELP72.HLB  —  INSERT  Format
  (B)0INSERT INTO qwq> <table-name> qqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqk    
               tq> <view-name> qqqqqj mq> AS <correlation-name> qqj x x    
               mq>  CURSOR <cursor-name> qqqqqqqqqqqqqqqqqqqqqqqqqqqj x    
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
  tqqq> DEFAULT VALUES qqqqqqqqqqqqqqqqqqwq>qwqqqqqqqqqqqqqqqqqqqqqwqwq>  
  tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqk x   mq> returning-clause qj x    
  mqqq> ( qw> <column-name> wq> ) qj   x x                           x    
           mqqqqqqqq , <qqqqj          x x                           x    
  lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqj x                           x    
  tq> value-clause qqqqqqqqqqqqqqqqqqqqqqj                           x    
  mq> select-expr qwqqqqqqqqqqqqqqqqqqqqwqqq>qqqqqqqqqqqqqqqqqqqqqqqqj    
                   mq> optimize-clause qj                                 

  (B)0value-clause =                                               
                                                               
   qqqq> VALUES q> ( qww> <parameter> qqqqqqqqqqwwq> ) qqq>    
                      xt> <qualified-parameter> ux             
                      xt> value-expr qqqqqqqqqqqux             
                      xm> DEFAULT qqqqqqqqqqqqqqjx             
                      mqqqqqqq , <qqqqqqqqqqqqqqqj             

  (B)0returning-clause =                                                 
                                                                     
  qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqwq> 
   tq> RETURNING value-expr qqqqqqqqqqqqqqqqum> INTO <parameter> j   
   mq> PLACEMENT ONLY RETURNING qwq> DBKEY qu                        
                                 mq> ROWID qj                        
                                                                     

  (B)0value-expr =                            
                                          
  qqqwqq> numeric-value-expr qqqqqwqqqqq> 
     tqq> char-value-expr qqqqqqqqu       
     tqq> date-time-value-expr qqqu       
     tqq> interval-value-expr qqqqu       
     tqq> date-vms-value-expr qqqqu       
     tqq> DBKEY qqqqqqqqqqqqqqqqqqu       
     tqq> NULL qqqqqqqqqqqqqqqqqqqu
     mqq> ROWID qqqqqqqqqqqqqqqqqqj       

  (B)0select-expr =                                                     
                                                                    
  qwqwq>  select-clause  qqqqqqqqqqqqwqwqqqqqqk                     
   x tq> ( select-expr )  qqqqqqqqqqqu x      x                     
   x mq>   TABLE table-ref qqqqqqqqqqj x      x                     
   mqqqqqq select-merge-clause <qqqqqqqj      x
     lqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqj                     
     mqwqqqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqqqwq>
       mq> order-by-clause qj  mq> offset-clause qj  mq> limit-to-clause qj

  (B)0optimize-clause =                                                 
                                                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq> 
    mq> OPTIMIZE qqwqwq> FOR qwq> FAST FIRST qqqqqqqqwqqqqqqqqqqwqwqj     
                   x x        tq> TOTAL TIME qqqqqqqqu          x x       
                   x x        mq> SEQUENTIAL ACCESS qj          x x
                   x tq> USING <outline-name> qqqqqqqqqqqqqqqqqqu x 
                   x tq> WITH qwq> DEFAULT  qqwq> SELECTIVITY  qu x
                   x x         tq> SAMPLED  qqu                 x x
                   x x         mq> AGGRESSIVE j                 x x
                   x mq> AS <query-name> qqqqqqqqqqqqqqqqqqqqqqqj x 
                   mqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
                                                                    

  (B)0select-merge-clause =                              
                                                     
  qwq> EXCEPT qwqqqqqqqqqqqqqqwqqqwqqqqwqqqqqqqqqqqqqqqqqqqwqq>
   x           mq> DISTINCT qqj   x    tq> CORRESPONDING qqu
   tq> INTERSECT qwqqqqqqqqqqqqqwqu    mq> NATURAL qqqqqqqqj
   x              mq> DISTINCT qj x
   tq> MINUS qqqqqqqqqqqqqqqqqqqqqu
   mq> UNION qqwqqqqqqqqqqqqqwqqqqj
               tq> ALL qqqqqqu
               mq> DISTINCT qj
Close Help