SQL$HELP72.HLB  —  DECLARE  CURSOR  Format
  (B)0DECLARE <cursor-name> qqqqqqqqqqqqqqqqqqqqk                      
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                      
  mqwqwqqqqqqqqqqqqqqqqwqq> TABLE CURSOR qqqwqqqqqqqqqqqqqqqqwqk   
    x tq> INSERT ONLY qu                    mq> with-clause qj x   
    x tq> READ ONLY qqqu                                       x   
    x mq> UPDATE ONLY qj                                       x   
    x lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
    x mq> FOR q> select-expr qqwqqqqqqqqqqqqqqqqqqqqqqwqqk         
    x                          mq> for-update-clause qj  x         
    x      lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj         
    x      mqwqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
    x        mq> optimize-clause qj                            x   
    mwqqqqqqqqqqqqqqqwwqqqqqqqqqwqwq> LIST CURSOR FOR SELECT k x   
     t> READ ONLY qqqjm> SCROLL j x                          x x   
     m> INSERT ONLY qqqqqqqqqqqqqqj                          x x   
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x   
    m> <column-name> WHERE CURRENT OF <table-cursor-name> qqqqqj   
                                                                   

  (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)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)0for-update-clause =                           
                                                
  qq> FOR UPDATE qwqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
                  mqwq> OF <column-name> qwqj   
                    mqqqqqqqq , <qqqqqqqqqj     
                                                

  (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