pureXML for DB2 for z/OS v9

    

Summary:
This course introduces the features and capabilities of pureXML as a new feature in DB2 for z/OS Version NINE. The SQL/XML capabilities are presented to access XML data with Select, Insert, Update, and Delete. The XML “path” type expression will be used to access a portion of the XML document hierarchy elements on the SELECT and WHERE clauses.

Duration:
1 Day/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 Version NINE table.

Topics:

• XML Overview
• CREATE TABLE with XML Column
• CREATE INDEX with XML Column “element pattern”
• XML Hierarchy Overview
• INSERT into XML Column
• UPDATE into XML Column
• SELECT with XMLQUERY
• WHERE with XMLEXISTS

Prerequisites:
Six months of SQL experience is recommended, but is not required. XML experience is helpful, but, not required.

Last Update: February 11, 2012