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.

SAP HANA®

SAP HANA supports UPDATE/DELETE with the WHERE CURRENT OF cursor clause in SQLScript, but not in pure SQL and ODBC client, used by the Genero ODI driver.

Solution

In pure SQL, UPDATE/DELETE ... WHERE CURRENT OF is not supported with SAP HANA.

As a replacement of WHERE CURRENT OF, if the database table is defined with a primary key column, use the value fetched from the SELECT [FOR UPDATE] cursor in the WHERE clause of the UPDATE/DELETE statement.