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.
PostgreSQL
PostgreSQL supports native scrollable cursors: The client application must use the
SCROLL option when declaring a server cursor.
Solution
The PostgreSQL database driver uses native scrollable cursors by declaring server cursors with
the SCROLL option.