Scrollable cursors
Informix®
Informix SQL and Genero BDL support scrollable
cursors when you specify the
SCROLL clause in the DECLARE
cursor instruction:DECLARE c1 SCROLL CURSOR FOR SELECT ...Microsoft™ SQL Server
Microsoft SQL Server supports native scrollable
cursors with the ODBC SQL_SCROLLABLE statement attribute.
Solution
All the SQL Server database drivers use the native SQL Server scrollable cursors,
by setting the ODBC statement attribute SQL_ATTR_CURSOR_SCROLLABLE
to SQL_SCROLLABLE.