Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : ODBC options : Using the block cursor switches

Using the block cursor switches

The DataServer provides one switch to enable or disable block cursors, and two switches to regulate memory consumption by block cursors. Block cursors also interact with the query tuning cache size allocations.
* Block cursors: the -Dsrv PRGRS_BLOCK_CURS,1 option
* Block cursor allocation by table: the -Dsrv PRGRS_TABLE_BLOCKSIZE,nnn option
* Total Block cursor allocation: the -Dsrv PRGRS_MAX_BLOCKSIZE,nnn option
* Impact of block cursors on cache size: the -Dsrv QT_CACHE_SIZE,nnn option
* Adjusting values