Purpose

The Enabled clause specifies whether the cache is enabled or disabled for use with SQL statements; it is optional.

Syntax

[ENABLED {YES | TRUE | NO | FALSE}]

where:

YES | TRUE
specifies that the cache is enabled. When a cache is enabled, the driver accesses the cached data for the remote table or view when a query is executed.
The driver does not check whether the cache needs to be refreshed when the Alter Cache statement is used to enable the cache. The check occurs the next time that the cache is accessed.
NO | FALSE
specifies that the cache is disabled, which means that the driver accesses the data in the remote table or view rather than the cache when a query is executed. The driver does not update the cache when inserts, updates, and deletes are performed on a remote table or view. To use the cache, you must enable it.
All data in an existing cache is persisted on the client even when the cache is disabled, except for the case where PERSIST is set to TEMPORARY.
The default is TRUE.