update_statement

The SQL statement UPDATE (update_statement) is supported in MaxDB with restricted syntax (UPDATE statement (update_statement)).

·        A correlated subquery is not permitted as a subquery (subquery) of a SET UPDATE clause in MaxDB.

·        If CURRENT OF <cursor> is specified, the results table in MaxDB must be based on an updatable table. A cursor built by a join or join view table is rejected.