Shred XML documents using DB2 pureXML
Two methods for XML decomposition in DB2 for Linux, UNIX, and Windows
From the developerWorks archives
Date archived: January 12, 2017 | First published: January 03, 2008
Since version 9.1, DB2 features significant new support for storing, managing, and searching XML data. One of these new features is annotated XML schema decomposition. Annotated XML schema decomposition allows you to decompose, or "shred", XML documents into relational tables. Another way to decompose XML documents is through the SQL or XML function: XMLTABLE. This article reviews the two methods of decomposing XML data including, how to use the XMLTABLE function for decomposition. It also compares annotated XML schema decomposition and XMLTABLE Decomposition and provides recommendations for the use of each.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.