CACHE Statements

The syntax for CACHE statements is:

  CACHE table_name [ WITH TRUNCATE ] [ WHERE search_condition ]

CACHE statements provide explicit control of the contents of the Local Cache database for the specified table.

A CACHE statement is equivalent to updating the results from a "SELECT * FROM table_name" query into the Local Cache. When used with a WHERE clause, existing rows already in the cache that do NOT match the specified criteria will not be updated.

When used with the WITH TRUNCATE clause, the local cache for the specified table will be deleted before executing the query from the data source and adding the cache. When used with both WHERE and WITH TRUNCATE clauses, only rows in the cache not matching the criteria will be deleted.

More information, including examples, can be found in the Caching Data section.