SQL$HELP72.HLB  —  CREATE  DATABASE  Arguments  LOCATION IS directory spec
    Specifies the name of the backing store directory to which row
    cache information is written. The database system generates a
    file name (row-cache-name.rdc) automatically for each row cache
    at checkpoint time. Specify a device name and directory name
    only, enclosed within single quotation marks. The file name is
    the row-cache-name specified when creating the row cache. By
    default, the location is the directory of the database root file.
    These .rdc files are permanent database backing store files.

    The LOCATION clause of the CREATE CACHE, ADD CACHE, or ALTER
    CACHE clause overrides this location, which is the default for
    the database.

    This clause is ignored if the row cache is defined to checkpoint
    to the database.
Close Help