This setting allows you to set the maximum number of rows a cursor will move when the user moves the scroll box in a scrolling window.
SQLDynamicScrollJump = number
• number - The maximum number of rows a cursor will move when a user moves the scroll box.
Data in a scrolling window is filled from its window buffer, which in turn is filled from the client buffer. The size of the client buffer equals the size of the cursor block being used. Each time new data is needed in the client buffer, the table is queried to retrieve the next cursor block of data. This setting can be used to limit the number of consecutive queries of the table that will be performed, thus limiting the length of time a user must wait for data to be displayed in the scrolling window.
For example, assume the cursor is positioned on the first row in a scrolling window that's filled using a cursor with a block size of 20. There are 5,000 rows in the table being queried, of which 1,000 meet the query criterion. If the scroll jump isn’t limited and a user drags the scroll box to the bottom of the scrolling window, he or she will have to wait for 50 consecutive queries of the database before the 1,000th row that meets the query criterion appears in the scrolling window (1,000 rows of results divided by 20 rows in the cursor block equals 50 queries).
By limiting the distance a cursor moves as the result of a single move of the scroll box, the SQLDynamicScrollJump setting can help limit the length of time a user must wait for the completion of an inadvertent move.
If a user moves the scroll box further than the distance limited by this setting, the scroll box will be repositioned to indicate the cursor's actual position within the table. For example, if a user drags the scroll box to the bottom of the scroll bar, but the cursor doesn't actually move to the end of the table, the scroll box will jump back to an intermediate position indicating its actual position within the table.
If users want to scroll further than the distance limited by this setting, they can continue moving the scroll box in the desired direction.
If this setting isn’t included in the defaults file, the system default of 100 rows will be used.