http://ibmsystemsmag.com/blogs/you-and-i/april-2019/announcing-ibm-i-7-4-and-db2-mirror-for-i/
Month: April 2019
Db2 Sql to get the first and last day of the month
Db2 Upsert using Merge into
Using Merge into statement, you can either insert or update a row. Merge into Syntax Merge into upsert_table as Temp using (values (1, 2, 3), (4, 5, 6), (7, 8, 9) —- more rows ) As Merge (C1, C2, C3) On Temp.Key_to_Match = Merge.Key_to_Match When Matched Then Update set temp.c1 = merge.c1, temp.c2 = merge.c2, […]