# System Parameters

'CL' | Cache Load

## Description

The 'CL' parameter setting times 1,000 defines the maximum number of records that can exist in a file to be cached via OPEN LOAD. The maximum setting for this parameter is 32,000 (32,000,000 records).

Database (ODB, OCI, DB2 and MYSQL) tables, EFF and VLR files that do not have either external keys or embedded IO procedures are subject to being cached based on the number of records they contain.

(The 'CL' system parameter was added in PxPlus 2019.)

## Default

1 (1,000 records)

## See Also

OPEN LOAD Caching