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 1 Day
Delivery Method Instructor Led
Public Price $600.00


DESCRIPTION (Return to Top)

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



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


TOPICS (Return to Top)
  • 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)


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 9 for z/OS.