DESCRIPTION
This 2 day course introduces the attendee to the new SQL, application and XML features of DB2 9 for z/OS.
AUDIENCE
This course is intended for application developers, database administrators, DB2 system programmers and application architects.
OBJECTIVES
Upon successful completion of this course, the student will:
- Understand the new SQL Features of DB2 9
- Be ready to implement and support these features in applications
- Be familiar with the PureXML features of DB2 9 for z/OS.
TOPICS
- Overview of DB2 9
- SQL Enhancements
- Native SQL Stored Procedures
- Optimizer Enhancements
- XML Overview
- CREATE TABLE with XML Column
- CREATE INDEX with XML Column “element pattern”
- XML Hierarchy Overview
- Inserting into an XML Column
- Updating an XML Column
- SELECT with XMLQUERY
- WHERE with XMLEXISTS
- Programming Language Support for DB2 XML
- XML Schemas, Validation and XML Schema Repository (XSR)
PREREQUISITES
Significant experience developing, administering or supporting applications that use a previous release of DB2 for z/OS. 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.
