In MySQL, \u00a0if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you\u00a0can use “ON DUPLICATE KEY UPDATE”.<\/p>\n
How to do it in DB2?<\/p>\n
Use “merge into” .<\/p>\n
MERGE INTO table_to_upsert AS tab\r\nUSING (VALUES\r\n (1, 2, 3),\r\n (4, 5, 6),\r\n (7, 8, 9)\r\n -- more rows\r\n ) AS merge (C1, C2, C3)\r\n ON tab.key_to_match = merge.key_to_match\r\n WHEN MATCHED THEN\r\n UPDATE SET tab.C1 = merge.C1,\r\n tab.C2 = merge.C2,\r\n tab.C3 = merge.C3\r\n WHEN NOT MATCHED THEN\r\n INSERT (C1, C2, C3)\r\n VALUES (merge.C1, merge.C2, merge.C3)<\/pre>\nFor example:<\/p>\n
MERGE INTO employees AS tab\r\nUSING (VALUES\r\n (123456,'smith','bob')\r\n ) AS merge (id,last_name,first_name)\r\n ON tab.id = merge.id\r\n WHEN MATCHED THEN\r\n UPDATE SET tab.id = merge.id,\r\n tab.last_name = merge.last_name,\r\n tab.first_name = merge.first_name\r\n WHEN NOT MATCHED THEN\r\n INSERT (id,last_name,first_name)\r\n VALUES (merge.id, merge.last_name, merge.first_name)<\/pre>\n<\/p>\n
See also:<\/p>\n
Upsert data from CSV to DB2<\/a>
\n Upsert data from TSV to DB2<\/a>
\n Upsert data from TXT to DB2<\/a>
\n Upsert data from Excel to DB2<\/a>
\n Upsert data from XML to DB2<\/a>
\n Upsert data from JSON to DB2<\/a>
\n Upsert data from SQL file to DB2<\/a><\/p>\nReplace (Update\/Insert) a row into other DB:<\/p>\n
In SQL Server,\u00a0https:\/\/www.withdata.com\/blog\/sql-server\/replace-update-or-insert-a-row-into-sql-server-table.html<\/a>\u00a0.<\/p>\n
In Oracle,\u00a0https:\/\/www.withdata.com\/blog\/oracle\/replace-update-or-insert-a-row-into-oracle-table-merge-into.html<\/a><\/p>\n
In PostgreSQL,\u00a0https:\/\/www.withdata.com\/blog\/postgresql\/replace-update-or-insert-a-row-into-postgresql-table.html<\/a><\/p>\n