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.
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.
April 2015 “Fun with SQL” third Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
Content Committee member Ben Anderson has written a very informative article on using the XQuery function fn:matches to provide regular expression pattern matching in SQL on the DB2 for LUW platform.
Access the article from the following link -
Within a few months we’ll have DB2 11 for z/OS, which contains some important enhancements to DB2’s pureXML feature. In this article, Isaac Yassin takes a look back at DB2’s previous XML support before previewing some of the new features introduced in DB2 11.