Syntax options:

    LOCATION IS directory-spec

    Specifies the name of the 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. By default, the location
    is the directory of the database root file. These .rdc files are
    permanent database files.

    This LOCATION clause overrides a previously specified location at
    the database level.

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