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.


SQLCursorBlockSize = block_size


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


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

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.

Documentation Feedback