VMS Help  —  SQLPRE72  Format
  (B)0EXEC SQL qqwqq> simple-statement qqqqwqqwqqqqqqqqqqqqqqqqqqqqqwqqq>
             mqq> compound-statement qqj  mqq> ending-symbol qqqj    
                                                                     

  (B)0ending-symbol =        
                         
  qqqqqwq> ; qqqqqqqqwq> 
       mq> END-EXEC qj   
                         

  (B)0simple-statement =         
                             
  qqqq> SQL statement qqqq>  

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

  (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 
                                                                    
Close Help