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 ...Oracle® MySQL and MariaDB
MySQL and MariaDB do not support scrollable cursors.
Solution
The MySQL and MariaDB database drivers emulate scrollable cursors by fetching rows in a temporary file.