This article is dedicated to SQL/XML functions. The article is built around simple examples to illustrate how those functions can be used in certain scenarios.
XMLModify function is introduced in DB2 10 for z/OS to do sub-document update, without reparsing the whole document. There is a big performance saving if the change is small when comparing to the size of the document.
XML and JSON support the storage of complex data structures. Standardizing your structures requires using a formal schema.
It is pretty clear that one of the key technologies of the moment is JSON. And this is reflected in many of the latest advances associated with DB2. There are many JSON-related developments. Should we give up on XML?
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.