Update XML in DB2 9.5

From the developerWorks archives

Matthias Nicola, Senior Software Engineer; Uttam Jain, Advisory Software Engineer

First published: October 11, 2007

One of the most significant new features in IBM® DB2® 9.5 for Linux, Unix and Windows is the XML update functionality. The previous version, DB2 9, introduced pureXML™ support for storing and indexing of XML data and querying it with the SQL/XML and XQuery languages. Modifications to an XML document were performed outside of the database server followed by an update of the full document in DB2. Now DB2 9.5 introduces the XQuery Update Facility, a standardized extension to XQuery that allows you to modify, insert, or delete individual elements and attributes within an XML document. This makes updating XML data easier and provides higher performance. This article describes the new XML update functionality, presents examples of typical XML update operations, and discusses how to avoid common pitfalls.

This content is no longer being updated or maintained. It is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.

Zone=Information Management, XML
ArticleTitle=Update XML in DB2 9.5