Cursors WITH HOLD

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.

Solution

Check that your source code does not use WITH HOLD cursors after transactions canceled with ROLLBACK.