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.