Additional support for pureXML®

Db2 12 enhances XML performance in several ways.

In Db2 12 of Db2 for z/OS, you can perform multiple document updates within a single XMLMODIFY invocation.

The updates can be in one of the following expressions in the xquery-update-constant of the XMLMODIFY function:

• A sequence expression
• A FLWOR expression that contains an updating expression in its return clause
• A conditional expression that contains an updating expression in its THEN or ELSE clause

In addition, Db2 12 improves the performance of XML queries by optimizing the choice of access plans.

The performance of XMLTable is also improved, in terms of the CPU time for constructing rows out of repeated elements that contain name-value pairs.

The XSLTRANSFORM function provides the ability to transform an XML document into a different data format. The output format can be any form possible for the XSLT processor, including, but not limited to, XML, HTML, and plain text.