In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
How to learn more about DB2? The answer is simple: DB2 Express-C, the community edition of DB2. You can learn, experiment and develop queries and applications through this easy to use and install version of DB2.
Why do we have routines in DB2? They allow us to include custom functionality inside our databases. But why do we need them? Should we use them?
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.