pureXML in Db2 for z/OS

PT27081
Summary
Get ready to become a power user of XQuery and XPath expressions in the processing of XML documents. Get ready to understand some of the efficiencies and inefficiencies of XML processing. Db2’s PureXML feature allows you to store well-formed XML documents as a column that has the XML data type. This allows for efficient search, retrieval, and updates within an XML document. This class spends time showing how to query these documents using the XQuery language (with XQuery expressions). Students will have many hands-on workshops to reinforce the topics and learn the most efficient ways to code and process.
Prerequisites
Some experience in SQL programming is recommended. Some previous experience in XML documents would be nice, but not required. The features in this course are noted below are for Db2 for z/OS.
Duration
3 Days/Lecture & Lab
Audience
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.
Topics
  • 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 Schema Repository (XSR)
  • Db2 XML – XQUERY
  • XML Performance

Related Scheduled Courses