Have you ever thought about using XML in DB2 for z/OS, but were afraid that you would need to study a lot of material before you could actually begin? Don’t worry! You do not need to know much before you start. You can get by with basic DB2 for z/OS knowledge.
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.
An under-appreciated set of ANSI SQL functions introduced over a decade ago could dramatically reduce application chattiness and improve response times.
This month’s third article is by John Maenpaa. John provides us with the overview of a real life project. The choice was between JSON, XML and traditional relation structure, in order to store complex forms. John talks about measurements and considerations. This article is a must read.
As I sit here on the last day of my summer vacation overlooking nature and holding a Jack on the rocks, determined to write this article, I can’t help but think: “wow times goes by fast.” I was going to write this article the first day, no wait the second... well you know the story.