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.