The Adaptive Server ODBC Driver supports the Static Insensitive scrollable cursor. It 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.
The Adaptive Server ODBC Driver supports the following scrolling types:
SQL_FETCH_NEXT – return the next rowset.
SQL_FETCH_PRIOR – return the prior rowset.
SQL_FETCH_RELATIVE – return the rowset n from the start of the current rowset.
SQL_FETCH_FIRST – return the first rowset in the result set.
SQL_FETCH_LAST – return the last complete rowset in the result set.
SQL_FETCH_ABSOLUTE – return the rowset starting at row n.
