Articles & Content

Archives

The XMLTABLE Function - A Swiss Army Knife for Application Developers (E15)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010



DATE: 2010-11-11 (08:30 - 09:30)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

What!? An entire presentation on just one SQL function? Yes! DB2 supports well over 200 functions that can be used in SQL statements, and one of them is XMLTABLE. What makes XMLTABLE different from most other functions are its powerful data transformation capabilities, its versatility, and its diverse set of use cases. Available in DB2 for z/OS and DB2 for Linux, UNIX, and Windows, the XMLTABLE function allows you to read XML data and return relational result sets to your application. It also enables you to create relational views over XML, shred XML to one or multiple relational tables, split large XML documents into smaller XML fragments, or map incoming XML data to a hybrid database schema that combines XML and relational columns. This presentation introduces the XMLTABLE function, demonstrates a set of common use cases, and provides guidelines to avoid errors.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Learn what the XMLTABLE function can do for you, no matter whether you convert XML to relational tables or use XML columns.

Learn how a single XMLTABLE function can save you from writing several pages of application code.

Learn how to use XMLTABLE in SELECT, INSERT, and UPDATE statements.

Learn how XMLTABLE eases the introduction of XML to your database by providing existing applications with relational views to your XML data.

Learn how to effectively use the XMLTABLE function in stored procedures and UDFs.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.