G532 DB2 and XML

Course Code: G-532
Recommended Duration: 3 Days

Benefits

The student learns how DB2 has implemented the XML data type, and how to work with XML data in SQL and in application programs.

Audience

Application programmers, database administrators, systems administrators, and sys tems programmers who will be involved in developing, maintaining, or enhancing systems that will use XML in DB2.

Prerequisites

The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for his/her job responsibilities.

Related IBM Materials

SC18-9858 - XML Guide (Version 9)
or
SC18-9858 - pureXML Guide (Version 10)

Major Topics Include

XML data type
XML catalog tables
XML functions for building XML documents
XML functions for accessing XML data
XPath expressions and functions
Working with XML data in application programs
XML and file reference variables
XML indexes and performance
DB2 utilities and XML
Using the UNLOAD utility with XML data
Using the LOAD utility with XML data
The DB2 XML schema repository
Stored procedures for managing the schema repository

Exercises

There are seven machine exercises.

Course Description

DB2 and XML