Tuesday, February 13, 2007

Getting the Most out of DB2 for z/OS and System z

As you might've noticed already, I have a keen interest in DB2. I worked for several years as a DBA on DB2 for z/OS as well as on DB2 for VM and VSE. Now the End of Service date of DB2 V7 for z/OS is announced (30/06/2008) and the announcement of DB2 V9 is near, I would like to draw your attention to the blog of Willie Favero : Getting the Most out of DB2 for z/OS and System z. I'm sure Willie Favero is going to pay lots of attention to the new version of DB2. Today he gives us a little foretaste on SQL improvements with "SQL MERGE - no more figuring which SQL statement to use". What's the story ? I quote : "Ever write an application that has to have logic to determine if a row exists before it is inserted. If the row doesn't exist, the row is inserted. However, if the row does exist, then you have to do an update. You have to code multiple SQL statements, if it's a distributed application, multiple trips through the network, and program logic to determine what action to take. What a pain!!!!". The solution : SQL Merge ! The rest of the post is over here.

No comments: