Which SQL statement supports an insert or an update in a single SQL statement?
A . MERGE
B . UPSERT
C . UPDATE or INSERT INTO …
D . INSERT INTO table … ON DUPLICATE KEY …
Answer: A
Explanation:
Reference: https://stackoverflow.com/questions/330241/does-db2-have-an-insert-or-update-statement