Articles & Content


Leverage the Power of SQL on XML Data (F10)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-21 (01:30 PM - 02:30 PM)
SPEAKERS: Mengchu Cai (IBM)

XML is becoming the standard for data exchange on the web and else where. Many industries have developed XML based message schemes. However, the majority of existing application software are developed based on a relational data model. A solution to extend these applications to handle XML messages without introducing major overhaul to existing software is desirable and also a challenge. DB2 z/OS v9 provides two features—XMLTABLE and XML Decomposition -- to help achieve this goal. XML decomposition is a stored procedure which decomposes an XML document into multiple relational tables. XMLTABLE is a built-in table function which can be used to create a relational view on top of XML documents. This presentation will compare these two features and present the audience best practices on how to use them to leverage the power of existing applications.

EXP. LEVEL: Beginner,Intermediate


Many banks in Europe are looking for a means to comply with the SEPA requirement without major changes in their existing payment applications. They can learn how to use DB2 to decompose SEPA messages so that their application can consume.

Some companies are planning to develop new applications based on service-oriented-architecture(SOA). They can learn how to design a database and application that can join XML messages with relational data that are used by existing services.

Some users plan to design an XML applications and they need the reporting functionality which the XPath query language lacks. They can learn how to create a relational view on their XML documents and leverage the GROUP BY and OLAP functions of SQL.

Some users need the XQuery FLWOR expression. But DB2 Z/OS v9 pureXML does not support XQuery yet. This presentation can help those users learn how to use XMLTABLE to write queries which is equivalent to the XQuery FLWOR expression.

Many users have to deal with huge XML documents which are composed by aggregating many smaller documents. They would like split those huge documents into smaller ones to make XML indexing more effective. They can learn how to use XMLTABLE to do that.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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