The size of the block cursor used for find operations on the table.
DataFlex SQL Drivers (SQL Server, DB2 and ODBC), revision 5 and higher
2..
The SQL drivers use database cursors to access data. For every table, two database cursors may be created: a single row cursor for find equal operations and a block cursor for every other find operation. Block cursors will get multiple rows when fetching data. The default value is 10 (rows).
Using block cursors speeds up find operations; it also creates a form of caching. The driver will get multiple records at a time. The next record will be fetched from memory, rather then from the back end. Using a cache introduces the risk of returning incorrect data. To avoid this, a find cache timeout can be set (in milliseconds). If the time between two find operation is larger than the find cache timeout (default 10 milliseconds), the driver will fetch the data from the back end even if not all records in the cache have been processed. The find cache timeout can be configured using the Find_Cache_Timeout driver configuration keyword.