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.

Dameng®

Dameng supports native scrollable cursors with the following DPI client API:

dpi_set_stmt_attr(handle, DSQL_ATTR_CURSOR_SCROLLABLE, DSQL_SCROLLABLE, 0);

Solution

The Dameng database driver uses the native scrollable cursors by setting the DPI statement attribute DSQL_ATTR_CURSOR_SCROLLABLE to DSQL_SCROLLABLE.