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

IBM® DB2®

IBM DB2 supports native scrollable cursors with the CLI SQL_CURSOR_STATIC statement attribute.

Solution

The IBM DB2 database driver uses the native scrollable cursors by setting the CLI statement attribute SQL_ATTR_CURSOR_TYPE to SQL_CURSOR_STATIC.