Articles & Content
Topic: 2008 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2008-05-20 (10:30 AM - 11:30 AM)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)
SQL is no longer the purely relational language that it used to be. The latest SQL standard defines an XML data type and new functions for querying hierarchical XML data. This is supported by DB2's pureXML functionality on zOS and Linux, Unix, and Windows. Apart from efficient storage and indexing, pureXML allows you to search and extract XML values through new the SQL functions. This also enables you to join XML and relational data in a single query, and to convert one to the other as needed. Additionally, you can apply the full power of all the good old relational SQL features to your XML data. This session introduces you to querying XML data in the DB2 9 family and presents tips & tricks for getting the best of both worlds when querying XML and relational data.
EXP. LEVEL: Beginner,Intermediate
Learn the basics of XPATH and how to use XPATH embedded in SQL to extract XML document fragments or to express predicates on XML data.
Learn how to query XML data in DB2, using the new SQL functions XMLEXISTS, XMLQUERY, and XMLTABLE.
Learn how to retrieve XML data in relational format, and vice versa, and how to apply any existing SQL functions and features to XML data.
Learn how to define relational views over XML to make your XML data available to your existing SQL applications.
Learn fundamental guidelines for write efficient queries, and for integrating XML and relational data.
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.