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.
LEARNING OBJECTIVES
Upon successful completion of this course, the student will be able to:
- Describe the importance of using XML for data storage
- Describe the XML data type and how DB2 for z/OS Version NINE stores the XML data
- List the advantages of using pureXML over the previous XML implementation
- 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
- Analyze sample queries to access XML data via XMLQUERY (SELECT) and XMLEXISTS (WHERE)
- Build and use XQUERY queries to access XML data for Select, Insert, Update, and Delete
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.
Prerequisites
Six months of SQL experience is recommended, but is not required. XML experience is helpful, but, no required.
Course duration
1 day
Course outline
1. XML Overview
- XML - Why? How?
- How XML data is stored
- XML data examples
2. CREATE TABLE with XML Column
- CREATE TABLE with an XML column
- Examples
3. CREATE INDEX with XML Column "element pattern"
4. XML Hierarchy Overview
- The XML Hierarchy
- Examples
5. INSERT into XML Column
- INSERT an XML document into an XML column in a DB2 table
- Examples
6. UPDATE into XML Column
- UPDATE an XML document into an XML column in a DB2 table
- Examples
7. SELECT with XMLQUERY
- XMLQUERY
- The XML "path" type expressions
- ALL Elements of the XML document
- Comparison Operators
- Sub-element access
- Example
8. WHERE with XMLEXISTS
- XMLEXISTS
- The XML "path" Expressions
- Comparison Operators
- Logical Operators
- Examples
Appendices
A. IBM Publications
B. PureXML URLs and Articles
C. pureXML Web Sites
|
