SQL$HELP72.HLB  —  Compound Stmt, Format
  (B)0compound-statement =                                        
                                                              
   qqwqqqqqqqqqqqqqqqqqqqqqqqwq> BEGIN qqwqqqqqqqqqqqqqqqqqqqqwqqqk
     mq> <beginning-label>: qj           mq> pragma-clauses qqj   x  
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
   mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqk  
     mwqq> variable-declaration qwj  x   
      mqqqqqqqqqqqqqqqqqqqqqqqqqqj   x  
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
   mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> END qqwqqqqqqqqqqqqqqqqqqqqwqq>
     mwq>  compound-use-statement  qwj          mq> <ending-label>: qj    
      mqqqqqqqqqq <qqqqqqqqqqqqqqqqqj

  (B)0pragma-clauses =

  qqwqwq> pragma-option qqwqqqqqqqqqqqqqqqqqqwqqq>
    x mqqqqqqq  <qqqqqqqqqj                  x
    mq> PRAGMA ( qwq> pragma-option  qwq> ) qj
                  mqqqqqqqq , <qqqqqqqj

  (B)0pragma-option =

  qqwq> ATOMIC qqqqqqqqqqqqqqqqqqqqqqwqq>
    tq> NOT ATOMIC qqqqqqqqqqqqqqqqqqu
    tq> ON ALIAS <alias-name> qqqqqqqu
    tq> with-clause qqqqqqqqqqqqqqqqqu
    mq> optimize-clause qqqqqqqqqqqqqj
     

  (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)0with-clause =                                           
                                                          
  qqq> WITH qq> HOLD qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
                      mq> PRESERVE qqwq> ON COMMIT qqqu   
                                     tq> ON ROLLBACK qu   
                                     tq> ALL qqqqqqqqqu   
                                     mq> NONE qqqqqqqqj   
                                                          

  (B)0variable-declaration =                                        
                                                                
  qqq> DECLARE qqwq> <variable-name> qwqwqqqqqqqqqqqqqqwqqk     
                 mqqqqqqqq , <qqqqqqqqj tq> CONSTANT qqu  x     
                                        mq> UPDATABLE qj  x     
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj     
  mqwq> data-type qqqqwqwqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqwq>
    mq> <domain-name> j mq> default-clause qj mq> constraint-clause qj
                                                                

  (B)0constraint-clause =

  qq> CHECK qq> (search-condition) qwqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
                                    mq> constraint-attributes qj

  (B)0default-clause =                               
                                                 
  qqwq> DEFAULT qqwqqwqq> date-time-literal qwqqqqq>
    mq>   = qqqqqqj  tqq> interval-literal  qu   
                     tqq> numeric-literal  qqu   
                     tqq> string-literal  qqqu
                     mqq> : <variable-name> qj

  (B)0compound-use-statement =                   
                                             
  qqqqwq> call-statement qqqqqqqqqqqqqqwqq> ;
      tq> commit-statement qqqqqqqqqqqqu     
      tq> control-statement qqqqqqqqqqqu     
      tq> delete-statement qqqqqqqqqqqqu     
      tq> get-diagnostics-statement qqqu     
      tq> insert-statement qqqqqqqqqqqqu     
      tq> lock-table-statement qqqqqqqqu     
      tq> rollback-statement qqqqqqqqqqu     
      tq> set-transaction-statement qqqu     
      tq> singleton-select-statement qqu     
      tq> start-transaction-statement qu
      tq> trace-statement qqqqqqqqqqqqqu     
      mq> update-statement qqqqqqqqqqqqj     

  (B)0control-statement =                    
                                         
  qqqwq> simple-case-statement qqqqqqwqq>
     tq> case-searched-statement qqqqu
     tq> compound-statement qqqqqqqqqu   
     tq> for-statement qqqqqqqqqqqqqqu   
     tq> for-counted-loop-statement qu
     tq> if-statement qqqqqqqqqqqqqqqu   
     tq> iterate-statement qqqqqqqqqqu   
     tq> leave-statement qqqqqqqqqqqqu   
     tq> loop-statement qqqqqqqqqqqqqu   
     tq> repeat-statement qqqqqqqqqqqu
     tq> return-statement qqqqqqqqqqqu   
     tq> set-assignment-statement qqqu   
     tq> signal-statement qqqqqqqqqqqu   
     tq> trace-statement qqqqqqqqqqqqu   
     mq> while-statement qqqqqqqqqqqqj  
Close Help