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.
You can force all cursors to be non-scrolling by setting the option FORCE_NO_SCROLL_CURSORS to ON. You may want to use this option to save on temporary storage requirements if you are retrieving very large numbers (millions) of rows.
