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 to 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 will be faster with this option set to OFF.
If your front-end application rarely performs backward-scrolling, make FORCE_NO_SCROLL_CURSORS = ‘ON’ a permanent PUBLIC option. It will use less memory and improve query performance.
