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.
Let’s have a brief look at the MERGE statement implementation in DB2. As I am primarily working on DB2 for z/OS, I will focus on this flavor of DB2. However, if there are any significant differences in the MERGE implementation in DB2 LUW, please share them in comments.
An under-appreciated set of ANSI SQL functions introduced over a decade ago could dramatically reduce application chattiness and improve response times.
In this comprehensive overview of DB2 10, for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
Check out this presentation by Joe Burns of Highmark that outlines some solutions to common problems with SQL.