FORCE_NO_SCROLL_CURSORS option

Function

Forces all cursors to be non-scrolling.

Allowed values

ON, OFF

Default

OFF

Scope

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.

Description

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 to 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 uses less memory and makes a modest improvement in query performance.