Pity the poor developer or end user that has never had the chance to use "real" SQL. You know, the kind of SQL that does more than select a few rows with possibly a few predicates thrown in?
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.
XMLModify function: sub-document update on an XML document
In DB2 9 for z/OS, an update on an XML document is a delete of whole document following by a new insert. Since DB2 10 for z/OS, we are able to do sub-document update using XMLModify function.
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.
This month’s topic is “advanced SQL”. This is always a tricky title, as what may be advanced to me, may not be advanced to you. So let me give you my definition of advanced SQL.