Cursors WITH HOLD

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

With Netezza®, cursors can be kept open when a transaction ends. However, cursors declared with a SELECT FOR UPDATE are not supported with Netezza.

Solution

Since WITH HOLD cursors are usually declared with SELECT FOR UPDATE and because Netezza does not support SELECT FOR UPDATE, you must review the program logic if you are using cursors declared WITH HOLD.