UPDATE/DELETE … WHERE CURRENT OF

Informix®

Informix allows positioned UPDATEs and DELETEs with the "WHERE CURRENT OF cursor" clause, if the cursor has been DECLARED with a SELECT ... FOR UPDATE statement.

Netezza®

Netezza servers do no support SELECT FOR UPDATE, and does not set locks.

Positioned UPDATE/DELETE with the WHERE CURRENT OF cursor clause cannot be supported with Netezza.

Solution

Review the program logic and rewrite all positioned UPDATE/DELETE with a WHERE condition based on primary keys or rowids.