SAP Sybase IQ cursors can be either scrolling or non-scrolling.
Non-scrolling cursors allow only the command forms FETCH NEXT and FETCH RELATIVE 0 to find and retrieve data. They do not keep track of which rows have been fetched. A cursor declared as DYNAMIC SCROLL is the same as a cursor declared as SCROLL.
Set the option FORCE_NO_SCROLL_CURSORS on to save on temporary storage requirements if you are retrieving very large numbers (millions) of rows. However, if your front-end application makes frequent use of backward-scrolling cursor operations, query response is faster with this option off.
If your front-end application rarely performs backward scrolling, make FORCE_NO_SCROLL_CURSORS = ‘ON’ a permanent PUBLIC option. It uses less memory and improves query performance.