SQL$HELP_OLD72.HLB  —  CREATE  CACHE  Format
  CREATE CACHE <row-cache-name> -+-+----------------------+-+->
                                 | +-> row-cache-params1 -+ |
                                 | +-> row-cache-params2 -+ |
                                 +------------ <------------+

  add-row-cache-clause =

  ---> ADD CACHE <row-cache-name> -+-+----------------------+-+->
                                   | +-> row-cache-params1 -+ |
                                   | +-> row-cache-params2 -+ |
                                   +-------------<------------+

  row-cache-params1 =

  --+-> ALLOCATION IS <n> -+--+-----------+----------------+->
    +-> EXTENT IS <n> -----+  +-> BLOCK --+                |
    |                         +-> BLOCKS -+                |
    +-> CACHE SIZE IS <n> -+----> ROW --+------------------+
    |                      +----> ROWS -+                  |
    +-> CHECKPOINT -+> UPDATED ROWS TO -+> BACKING FILE -+-+
    |               |                   +> DATABASE -----+ |
    |               +> ALL ROWS TO BACKING FILE ---------+ |
    +-> LARGE MEMORY IS ----+-+-> ENABLED --+--------------+
    +-> ROW REPLACEMENT IS -+ +-> DISABLED -+              |
    +-> LOCATION IS --> <directory-spec> ------------------+
    +-> NO LOCATION ---------------------------------------+

  row-cache-params2 =

  --+-> NUMBER OF -+-> RESERVED -+-> ROWS IS <n> --------------+->
    |              +-> SWEEP ----+                             |
    +-> ROW LENGTH IS <n> -+-------------+---------------------+
    |                      +----> BYTE --+                     |
    |                      +----> BYTES -+                     |
    |                                                          |
    +-> ROW SNAPSHOT IS --+-> ENABLED rs-opt  -+---------------+
    |                     +-> DISABLED --------+               |
    |                                                          |
    +-> SHARED MEMORY IS --+----> SYSTEM -------------------+--+
                           +----> PROCESS --+-------------+-+
                                            |             |
                                            +-> RESIDENT -+

  rs-opt =
  --+-------------------------------+--->
    +-> (CACHE SIZE IS <n> ROWS) ---+
Close Help