SQL$HELP72.HLB  —  DECLARE  TRANSACTION  Format
  (B)0DECLARE TRANSACTION qqwqqqqqqqqqqqqqqqwq>   
                        tq> tx-options qu     
                        mq> db-txns qqqqj     

  (B)0tx-options =                                         
                                                       
  qqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq> 
    x tq> NAME 'quoted-string' qqqqqqqqqqqqqqqqu x
    x tq> EVALUATING qwq evaluating-clause qqwqu x
    x x               mqqqqqqq> , <qqqqqqqqqqj x x
    x tq> RESERVING qqwq> reserving-clause qqwqu x     
    x x               mqqqqqqqq , <qqqqqqqqqqj x x
    x tq> isolation-level qqqqqqqqqqqqqqqqqqqqqu x
    x tq> transaction-mode qqqqqqqqqqqqqqqqqqqqu x
    x mq> wait-option qqqqqqqqqqqqqqqqqqqqqqqqqj x
    mqqqqqqqqqqqqqqqqwqqqqqqqwqqqqqqqqqqqqqqqqqqqj
                     mqq , <qj

  (B)0evaluating-clause =                                               
                                                                    
  qwqqqqqqqqqqqqqwq> <constraint-name> q> AT qwq> VERB TIME qqqwqq> 
   mq> <alias.> qj                            mq> COMMIT TIME qj    
                                                                    

  (B)0reserving-clause =                                                         
                                                                             
  qwqwq> <view-name> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqk   
   x mq> <table-name> qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqj x x   
   x                   mq> PARTITION qq> ( qwq> <part-num> qwq> ) qj   x x   
   x                                        mqqqqqq , <qqqqqj          x x   
   mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj x   
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
   mq> FOR qwqqqqqqqqqqqqqqwqqwq> READ qqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqq>   
            tq> EXCLUSIVE qu  tq> WRITE qqqqqqqqqqqu                         
            tq> PROTECTED qu  mq> DATA DEFINITION qj                         
            mq> SHARED qqqqj                                                 
                                                                             

  (B)0isolation-level =

  qqq> ISOLATION LEVEL qqwq> READ COMMITTED qqqqwqq>
                         tq> REPEATABLE READ qqqu
                         mq> SERIALIZABLE qqqqqqj

  (B)0transaction-mode =

  qqwq> READ ONLY qqqqwq>
    tq> READ WRITE qqqu
    mq> BATCH UPDATE qj

  (B)0wait-option =
  qqwq> WAIT qwqqqqqqqqqqqqqqqqqqqqqwqwq>
    x         mq> <timeout-value> qqj x
    mq> NOWAIT qqqqqqqqqqqqqqqqqqqqqqqj

  (B)0db-txns =                                                            
                                                                       
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
    mwq> ON qwq> <alias> qwq> USING qq> ( wq> tx-options qqwq> ) qwj   
     x       mqqqq , <qqqqj               mq> DEFAULTS qqqqj      x    
     mqqqqqqqqqqqqqqqqqqqqqqqqqq AND <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
                                                                       
Close Help