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.