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.