Published at LXer:
XMLTABLE is one of the most powerful functions in the SQL/XML standard and is available in DB2 9 for Linux, Unix, Windows, and z/OS. In part 1 of this two-part series you learned how to use XMLTABLE to retrieve XML data in relational format, how to deal with repeating or missing XML elements, and how to handle namespaces. Part 2 describes common XMLTABLE usage scenarios, such as shredding XML into relational tables, and producing hybrid XML-relational storage of your XML documents.
Read More...
