SQLCursorBlockSize

This setting allows you to determine the number of rows of data included in a cursor block. The cursor block is used to copy data to the client buffer from the server-based table.

Syntax

SQLCursorBlockSize = block_size

Parameters

• block_size - An integer representing the number of rows to include in a cursor block.

Comments

The cursor block size specified in this setting is used when both of the following conditions are met:

The open table statement's with blocksize clause isn't used when opening the table from which the result data is retrieved.
The Default option is selected in the Block Size field of the Table Options window for the table from which the result data is retrieved.

If both of the above criteria are met and the SQLCursorBlockSize setting isn't included in the defaults file, the cursor block size will be set to the system default value of 25 rows. The maximum number of rows allowed is 255. If this setting is included in the defaults file with a value greater than 255, 255 rows will be used.