SQL adaptation guide For IBM Netezza 1.x / BDL programming |
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® servers do no support SELECT FOR UPDATE, and does not set locks. Thus, positioned UPDATEs/DELETEs with the WHERE CURRENT OF<cursor> clause cannot be supported with Netezza.
You must review the program logic and rewrite all positioned UPDATEs/DELETEs with a WHERE condition based on primary keys or rowids.