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

SAP HANA®

SAP HANA does not support scrollable cursors.

Solution

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

See Scrollable cursors for more details about scroll cursor emulation.