Previous Topic: PROCESS ParameterNext Topic: STACKERROR Parameter


SQLPOOLSIZE Parameter

This parameter determines the size of the storage pool used by the RDF to contain SQL data.

The size of this pool must be at least as large as the amount of data returned by the largest SQL request.

Default value

1024 KB

Other possible values

Any amount of storage between 524288 bytes (512 KB) and 67108864 (64 MB) bytes

Set or modify this parameter…

At initialization

Example: SQLPOOLSIZE

This function limits the MSF storage pool to 2 MB.

OPSPRM('SET','SQLPOOLSIZE','2048K')