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.