Progress
Language Reference
SAVE CACHE Statement
Saves the schema cache of a database to an operating system file. Subsequent sessions can then share the same cache by using the Schema Cache File (-cache) parameter.
SYNTAX
CURRENT
Specifies that only the portion of the schema cache that applies to referenced tables is saved to the file. By using this option you can tailor a small schema cache file for an application that does not use all the tables in the database.
COMPLETE
Specifies that the complete schema cache for the database is saved to the file. If you use this option, the client process builds a complete schema cache in memory including template records and all trigger information for every table in the database.
database-name
Specifies the literal logical name of a currently connected Progress database.
pathname
Specifies the literal pathname of an operating system file to hold the schema cache.
VALUE (char-expr)
Returns the corresponding literal database name or pathname specified by the character expression in char-expr.
NO-ERROR
Specifies that any errors that occur in the attempt to save the schema cache file are suppressed. After the SAVE CACHE statement completes, you can check the ERROR-STATUS system handle for information on any errors that occurred.
EXAMPLEThis procedure saves the complete schema cache for each database that you specify in the current working directory, and displays any error messages associated with connecting or saving the cache.
NOTES
- The schema cache is saved to the file in a binary format that is portable across machines.
- For information on using an existing schema cache file, see the Progress Database Administration Guide and Reference. For information on the Schema Cache File (-cache) startup parameter, see the Progress Startup Command and Parameter Reference.
- Any schema changes to the database make the saved cache invalid. If the schema cache file is invalid when Progress tries to access it, Progress displays a warning message, ignores the file, and reads the required schema cache from the database.
- To set up your database environment to use the CURRENT option, you only have to connect to the database and read from the tables that compose the schema you want to save. This is sufficient for the SAVE CACHE statement to save all parts of each table in the schema, including template records and trigger information. If you want to save a different subschema of the database, you must disconnect and then reconnect to the database before reading the tables for that subschema.
- For a DataServer, Progress saves the schema cache for the entire schema holder database. You cannot save the schema cache for a non-Progress database separately. For more information on schema cache files for DataServers, see the Progress DataServer Guides , Progress DataServer for ODBC Guide and Progress DataServer for ORACLE Guide.
SEE ALSO
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |