Forces all cursors to be non-scrolling.
ON, OFF.
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
OFF
By default, all cursors are scrolling. Scrolling cursors with no host variable declared cause Sybase IQ to create a buffer for temporary storage of results. Each row in the result set is stored to allow for backward scrolling.
Setting FORCE_NO_SCROLL_CURSORS = “ON” forces all cursors to be non-scrolling, thereby saving on temporary storage requirements. This option can be useful if you are retrieving very large numbers (millions) of rows, however some front-end applications make use of scrolling cursor operations and require this option to be set "OFF".
If scrolling cursors are never used in your application, you should make this a permanent public option. It will use less memory and make a modest improvement in query performance.
