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.
April 2015 “Fun with SQL” fourth Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
DB2 11 for z/OS is here, and IDUG has the first user review in our DB2 11 for z/OS user technical perspective white paper.