Cursors WITH HOLD

Informix® closes opened cursors automatically when a transaction ends unless the WITH HOLD option is used in the DECLARE instruction.

By default Genero db keeps cursors open when a transaction ends (however, FOR UPDATE locks are released at the end of a transaction).

Solution

BDL cursors are automatically closed when a COMMIT WORK or ROLLBACK WORK is performed.

WITH HOLD cursors with a SELECT FOR UPDATE can be supported, if the table has a primary key or a unique index.