Scrollable

The scrollable behavior of a cursor defines the fetch options the cursor supports.

If the SCROLL keyword is specified on a DECLARE statement, or if SQL_ATTR_CURSOR_SCROLLABLE is set to SQL_SCROLLABLE, the cursor supports all of the fetch options.

If the SCROLL keyword is omitted from a SQL-92 style DECLARE statement or if SQL_ATTR_CURSOR_SCROLLABLE is set to SQL_NONSCROLLABLE, the cursor supports only fetch next operations.

See Also