Previous Topic: SQL CACHE Statement UsageNext Topic: STORAGE POOL Statement—Defines Secondary 24-Bit Storage Pools

System Generation Statements › SQL CACHE Statement—Controls SQL Caching › Example: SQL CACHE Statement

Example: SQL CACHE Statement

Enabling an SQL Cache

The following statement enables an SQL cache to hold up to 500 SQL statements. Caching will be active for all connect names except for the SYSTEM dictionary.

ADD SQL CACHE
 FOR 500 STATEMENTS
 DEFAULT CACHING IS ON
 EXCEPT CONNECT TO(SYSTEM).

Modifying the Connect Exception List

The following statement will set the dictionaries SYSTEM and APPLDICT in the exception list.

MOD SQL CACHE
 EXCEPT CONNECT TO(SYSTEM APPLDICT).

Removing SQL caching

The following statement removes the SQL cache from the current system definition. Please note that it will still be possible to dynamically add SQL caching through SQL DML statements. Refer to the examples in the appropriate appendix of the CA IDMS SQL Reference Guide.

DELETE SQL CACHE.