MERGE statement enhancements
Db2 12 introduces changes to the SQL MERGE statement that provide more functionality and improve compatibility with the Db2 family.
Enhancements to the MERGE statement include support for:
- table-reference as an alternative way of specifying source data for the MERGE statement
- Multiple MATCHED clauses
- Additional predicates with MATCHED or NOT MATCHED
- DELETE operations
- IGNORE and the SIGNAL statement as actions