Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.
DB2 includes support for On-Line Analytical Processing (OLAP) built-in functions. The first three functions introduced may be used to rank and number rows in a result table. This article will explore these three functions which are available on both DB2 for z/OS and DB2 for LUW.
DB2 10.1 and 10.5 offer new and improved SQL features, many of which can benefit existing DB2 LUW applications without disrupting their design. This article highlights some relatively approachable SQL enhancements that, once adopted, could at least simplify if not accelerate older DB2 applications.
I am a big fan of minimizing the calls to DB2 and run as few SQL as possible. That is one of the reason I like the MERGE statement although it is a bit limited in DB2 for z/OS. In this short blog I would like to mention another of my favorite SQL tricks - SELECT FROM data-change-table-reference.
The new The SQL Reference for Cross-Platform Development has arrived
In May of this year, IBM published the newest version of The SQL Reference for Cross-Platform Development. It is intended for developers who build applications that need to be portable across the DB2 family.