This is a subclause of other clauses and has different effects,
    depending upon the clause in which it is used, as follows:

    o  In the row-cache-options clause

       Removes the location previously specified in a LOCATION IS
       clause for the row cache. If you specify NO LOCATION, the
       row cache location becomes the directory of the database root
       file.

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

    o  In a CREATE CACHE, ADD CACHE, or ALTER CACHE clause (row-
       cache-params1 clause)

       Removes the location previously specified in a LOCATION IS
       clause for the row cache backing file. If you specify NO
       LOCATION, the row cache location becomes the directory of
       the database root file.

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