XML enhancements
Db2 11 provides enhanced support for XML data.
Db2 implicitly adds a document node when it stores data with the following statements:
- INSERT
- UPDATE
- XMLDOCUMENT
Db2 issues fewer error SQLCODEs when it evaluates XPath predicate expressions with an explicit cast or an operation with an invalid value. If the XML data that is processed is filtered from the result, then processing the query continues. Examples of XPath expressions that have fewer errors include the following situations:
- When data is filtered from the result by the predicate before an invalid operation. For example, an operation calculates a division of a number by zero.
- When data is explicitly cast to an incompatible data type.
The LOAD utility performance is improved when it loads binary XML data that has been previously validated. When certain conditions are met, you might see improvements to CPU time when you are loading binary XML data that was created with the UNLOAD utility.