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 ...

Important:

Informix does not allow to fetch TEXT/BYTE columns with scrollable cursors. If you declare a scroll cursor with a SELECT containing TEXT/BYTE columns, Informix will produce the SQL error -611 when executing the OPEN instruction.

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.