Cursors declared WITH HOLD

You can use the WITH HOLD option on a cursor that is defined on a nickname.

For the DRDA wrapper and the Db2® data source, cursors that you declare using the WITH HOLD option remain open across multiple units of work.

If you declare a cursor WITH HOLD and the data source does not support this option, the attribute is ignored.