The UPDATE (update_statement) SQL statement is supported in SAP MaxDB with restricted syntax ( UPDATE statement).
A Correlated Subquery is not permitted as a subquery (subquery) of a SET UPDATE clause in SAP MaxDB.
If CURRENT OF <cursor> is specified, the results table in SAP MaxDB must be based on an updatable table. A cursor built by a join or join view table is rejected.