September 22, 2007

Develop powerful XML applications with DB2

Author: JT Smith

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.

Link: IBM developerWorks

Categories:

  • Programming
  • Databases
Click Here!