Background documentationupdate_statement Locate this document in the navigation structure


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.