upsert sql db2

Somasundaram1 · #1 (**permalink**) 10-26-09, 21:39

i know other database have upsert. but not db2. why not db2?

Marcus_A · #2 (**permalink**) 10-26-09, 22:05

In DB2 it is called MERGE. Basically the same thing.

Somasundaram1 · #3 (**permalink**) 10-27-09, 00:03

merge require another table - yes? i want upsert for one row at time - can i do this?

tonkuma · #4 (**permalink**) 10-27-09, 02:35

You can use (VALUES ...) or (SELECT ... FROM sysibm.sysdummy1) for merging table(table-reference in USING clause).

stolze · #5 (**permalink**) 10-27-09, 13:46

The SQL standard (and DB2) calls this MERGE. UPSERT originates from the times where this functionality was not standardized yet.