The last post of the XML series. This time we discuss the Db2 12 that introduced a couple of interesting enhancements to the SQL/XML functions.
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?