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

SQLite

SQLite does not support scrollable cursors.

Solution

The SQLite database driver emulates scrollable cursors by fetching rows in a temporary file.

See Scrollable cursors for more details about scroll cursor emulation.