This course introduces the attendee to the new PureXML features of DB2 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

• DB2 PureXML Overview
• DB2 and XPATH
• Using XML with DB2
• CRUD with XML
• The XMLTABLE Function
• Programming Language Support for DB2 XML
• Indexes and XML
• XML Schemas, Validation and XML Schemas Resository (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.