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.
In March 2016, IBM introduced a new certification test for DB2 for z/OS - C2090-320 DB2 11 Fundamentals for z/OS. It is an entry level test that opens the door for other more advanced certifications. Let's here go through and review all test sections.
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!
A singleton SELECT - is this always the best solution for readability and performance? The article discusses a simple scenario, that shows that a singleton SELECT can result in surprising application behavior if not used properly.