Toad World Blog

Db2 12 for z/OS SQL Enhancements: a Better MERGE

Aug 17, 2017 11:22:00 PM by Robert Catterall

Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the series described piece-wise DELETE and result set pagination . This entry focuses on the new and very much improved MERGE functionality delivered via Db2 12 (usable at function level V12R1M500 and above). The MERGE statement, introduced with Db2 9 for z/OS, is sometimes referred to as the "upsert" statement, because it enabled, via a combination of ...read more

 

Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS SQL

Robert Catterall

Written by Robert Catterall