| SQL adaptation guide for IBM Netezza 6.x / BDL programming | |
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.
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.