DC/UCF System Reports—CREPORTS › SQL CACHE Reports (CREPORTs 047 and 048) › Field Descriptions

Field Descriptions

A description of the fields in the sample report follows:

SYSTEM VERSION

Identifies the system whose SQL CACHE runtime definitions are being described.

DEFAULT CACHING

Specifies whether caching of dynamic SQL statements is enable by default.

n STATEMENTS

Specifies the maximum number (n) of SQL statements that can be placed in SQL CACHE.

EXCEPT CONNECT TO

Identifies the name of a dictionary/catalog to which a user of the CV can connect. The connect-names form an exception list to the default caching specification.