Do you need to switch between managing databases in the different DB2 instances frequently? In this blog you will learn how you can easily manage multiple instances and simplify the switch.
Today we will introduce the XQuery language and cover a basic subset of this language, including constructor and FLWOR expressions. Both expressions will be useful in SQL/XML functions in DB2 for z/OS.
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!