Library /sys$common/syshlp/SQL$HELP72.HLB  —  CREATE  CACHE  Format
  (B)0CREATE CACHE <row-cache-name> qwqwqqqqqqqqqqqqqqqqqqqqqqwqwq> 
                                 x tq> row-cache-params1 qu x   
                                 x mq> row-cache-params2 qj x   
                                 mqqqqqqqqqqqq <qqqqqqqqqqqqj

  (B)0add-row-cache-clause =                                        
                                                                
  qqq> ADD CACHE <row-cache-name> qwqwqqqqqqqqqqqqqqqqqqqqqqwqwq>
                                   x tq> row-cache-params1 qu x 
                                   x mq> row-cache-params2 qj x 
                                   mqqqqqqqqqqqqq<qqqqqqqqqqqqj

  (B)0row-cache-params1 =                                          
                                                               
  qqwq> ALLOCATION IS <n> qwqqwqqqqqqqqqqqwqqqqqqqqqqqqqqqqwq> 
    tq> EXTENT IS <n> qqqqqj  tq> BLOCK qqu                x   
    x                         mq> BLOCKS qj                x   
    tq> CACHE SIZE IS <n> qwqqqq> ROW qqwqqqqqqqqqqqqqqqqqqu   
    x                      mqqqq> ROWS qj                  x   
    tq> CHECKPOINT qw> UPDATED ROWS TO qw> BACKING FILE qwqu
    x               x                   m> DATABASE qqqqqu x
    x               m> ALL ROWS TO BACKING FILE qqqqqqqqqj x
    tq> LARGE MEMORY IS qqqqwqwq> ENABLED qqwqqqqqqqqqqqqqqu   
    tq> ROW REPLACEMENT IS qj mq> DISABLED qj              x   
    tq> LOCATION IS qq> <directory-spec> qqqqqqqqqqqqqqqqqqu   
    mq> NO LOCATION qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
                                                               

  (B)0row-cache-params2 = 
                      
  qqwq> NUMBER OF qwq> RESERVED qwq> ROWS IS <n> qqqqqqqqqqqqqqwq>
    x              mq> SWEEP qqqqj                             x
    tq> ROW LENGTH IS <n> qwqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqu 
    x                      tqqqq> BYTE qqu                     x 
    x                      mqqqq> BYTES qj                     x 
    x                                                          x
    tq> ROW SNAPSHOT IS qqwq> ENABLED rs-opt  qwqqqqqqqqqqqqqqqu
    x                     mq> DISABLED qqqqqqqqj               x
    x                                                          x
    mq> SHARED MEMORY IS qqwqqqq> SYSTEM qqqqqqqqqqqqqqqqqqqwqqj 
                           mqqqq> PROCESS qqwqqqqqqqqqqqqqwqj    
                                            x             x     
                                            mq> RESIDENT qj     

  (B)0rs-opt =  
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq>
    mq> (CACHE SIZE IS <n> ROWS) qqqj
Close Help