On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(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
  • INSERT, UPDATE and DELETE with XML
  • 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
  • DB2 XML - XQUERY


PREREQUISITES (Return to Top)

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.