This 1 day course introduces the attendee to the new PureXML features of DB2 9 for z/OS.

This course is intended for business analysts, end users, programmers and team leads who need to use pureXML to access XML data in a DB2 for z/OS table.

Upon successful completion of this course, the student will be able to:

• Describe the importance of using XML for storage
• Describe the XML data type and how DB2 for z/OS stores the XML data
• List the advantages of using PureXML over the previous XML implementation
• Explain using the XML “path” type expression to access a portion of an XML document
• Review and discuss sample queries that illustrate SQL/XML capabilities to access XML data
• Build and use SQL/XML queries to access XML data for Select, Insert, Update, and Delete

• XML Overview
• CREATE TABLE with XML Column
• CREATE INDEX with XML Column “element pattern”
• XML Hierarchy Overview
• Inserting into an XML Column
• Updating an XML Column
• SELECT with XMLQUERY
• WHERE with XMLEXISTS
  Programming Language Support
  for DB2 XML
• XML Schemas, Validation and XML
  Schema Repository (XSR)

Significant experience using SQL is recommended. The Fundamentals of XML course or previous experience with XML is recommended. The features discussed require DB2 9 for z/OS.