System Generation Statements › SQL CACHE Statement—Controls SQL Caching › SQL CACHE Statement Parameters

SQL CACHE Statement Parameters

statement-count

Specifies the maximum number of SQL statements that can be placed in the SQL statement cache. The default value is 100. The maximum theoretical value is 2,147,483,647. The actual maximum depends on available memory.

DEFault caching

• ON - Specifies that caching of dynamic SQL statements is enabled. ON is the default.
• OFF - Specifies that caching of dynamic SQL statements is disabled.

connect-name

Specifies the name of a dictionary or catalog to which a user of the CV can connect. You can specify multiple connect-names to form an exception list to the default caching specification.