Consultor Eletrônico



Kbase P95276: The SAVE CACHE CURRENT Statement appears to generate the same size cache file like the SAVE CACHE CO
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   22/09/2004
Status: Unverified

SYMPTOM(s):

The SAVE CACHE CURRENT Statement appears to generate the same size cache file like the SAVE CACHE COMPLETE Statement.

First executed code similar to:
DEFINE VARIABLE db-name AS CHARACTER FORMAT "x(12)" INITIAL "sports2000".
SAVE CACHE COMPLETE VALUE(db-name) to VALUE(db-name + ".csh") NO-ERROR.
This generated a 61K size 'sports2000.csh cache.

First executed code similar to:
DEFINE VARIABLE db-name AS CHARACTER FORMAT "x(12)" INITIAL "sports2000".
SAVE CACHE CURRENT VALUE(db-name) to VALUE(db-name + ".csh") NO-ERROR.
This also generated a 61K size 'sports2000.csh cache.

CAUSE:

Developer did not disconnect from the database after generating the first cache file using the SAVE CACHE COMPLETE Statement.

FIX:

To save a different subschema of the database, disconnect and then reconnect to the database before reading the tables for that subschema.