Come and learn the basics of writing SQL along with a few tips on more advanced features of SQL. Examples will use system views and table functions available in DB2 10.5. This video is geared towards DBAs who don't write SQL on a regular basis and anyone who wants to take a basic look at writing SQL
We are approaching the part of test 313 related to program coding and preparation called Coding SQL in Applications Programs. From my viewpoint, this part refers to traditional z/OS applications and their preparation, but certainly it might useful for programmers of other applications as well.
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.