SQL adaptation guide For Genero db 3.6x, 3.8x / BDL programming |
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).
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.