We are getting back on track how to access and manipulate XML documents in DB2 for z/OS. But this time, with focus on more complex XML data manipulation techniques than just selecting/inserting/updating, or deleting the whole XML document.
When you exchange XML documents between different systems or applications, you may need a construct that ensures your applications will “understand” the XML documents that are being exchanged. And this is where XML schema comes into a play!
Let's spend some time in this post with the pureXML storage concept, discussing how DB2 stores XML documents in the database. You may think this is too theoretical; that it is something happening in the background that you don’t need to know. But give it a try!
Today we will discuss how LOAD and UNLOAD utilities and file reference variables can help you to overcome inefficiencies in XML document maintenance with standard SQL statements.
One could say that we are almost at the end of our journey. The DB2 11 Application Developer for z/OS certification test consists of 10 sections so this writing should be the end of the story, right? Well, sort of.
First, thank you if you read these blogs, hopefully you found them interesting and