Purpose

Specifies whether the driver refreshes a dirty cache on the next fetch operation from the cache. A cache is marked as dirty when a row is inserted into or deleted from a cached table or a row in the cached table is updated.

Valid Values

1 | 0

Behavior

If set to 1, a dirty cache is refreshed when the cache is referenced in a fetch operation. The cache state is set to initialized if the refresh succeeds.

If set to 0, a dirty cache is not refreshed when the cache is referenced in a fetch operation.

Default

1

Data Type

int

See also

Refreshing Cache Data