On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB1091 PureXML in DB2 for z/OS
Duration 2 Days
Delivery Method Instructor Led
Public Price $1125.00

DESCRIPTION (Return to Top)

This course introduces the attendee to the PureXML features of DB2 for z/OS versions 8 through 11.

AUDIENCE (Return to Top)

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.

OBJECTIVES (Return to Top)

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
  • Build and use new XQuery features including FLWOR expressions and their join syntax

TOPICS (Return to Top)
  • DB2 PureXML Overview
  • DB2 and XPATH
  • Using XML with DB2
  • The XMLTABLE and XMLCAST Functions
  • Programming Language Support for DB2 XML
  • Indexes and XML
  • XML Schemas, Validation and XML Schemas Repository (XSR)
  • Version 10 XML New Features


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