XMLTABLE by Example, Part 1: Retrieving XML Data in Relational Format - Harness the Power of This Useful SQL/XML Function in DB2

Overview

DB2 pureXML provides hierarchical storage for XML data and advanced XML query capabilities such as SQL/XML and XQuery. SQL/XML is a standardized extension of the SQL language so that XQuery or XPath can be embedded in SQL. This allows for integrated processing of XML and relational data, or conversion from one to the other. One of the most versatile functions in SQL/XML is XMLTABLE.