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.
What are XML related zParms?
I have been asked this question so many times that I decide to write a short article on this. Here is a list of some commonly used XML zParms.
DB2 for z/OS is no longer about the traditional relational structured data only. The evolution brought us not only binary objects, or XML and JSON, but also other non-structured data living in a distributed file system such as HDFS.