The Adaptive Server ODBC Driver supports the Static Insensitive scrollable cursor. The Static Insensitive implements the ODBC SQLFetchScroll method to scroll and fetch rows.
The SQLFetchScroll method is a standard ODBC method defined in Microsoft Open Database Connectivity Software Development Kit Programmer’s Reference, Volume 2, which is part of the MSDN library.
SQL_FETCH_NEXT – returns the next rowset.
SQL_FETCH_PRIOR – returns the prior rowset.
SQL_FETCH_RELATIVE – returns the rowset n from the start of the current rowset.
SQL_FETCH_FIRST – returns the first rowset in the result set.
SQL_FETCH_LAST – returns the last complete rowset in the result set.
SQL_FETCH_ABSOLUTE – returns the rowset starting at row n.