SQL adaptation guide For IBM DB2 UDB 8.x, 9x / BDL programming |
Informix® provides the WITH HOLD option to prevent cursors being closed when a transaction ends.
This feature is well supported when using the DB2® interface, except when a transaction is canceled with a ROLLBACK, because DB2 automatically closes all cursors when you rollback a transaction.
Check that your source code does not use WITH HOLD cursors after transactions canceled with ROLLBACK.