On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB1095 DB2 9 for z/OS Application & XML Features
Duration2 Days
Delivery MethodInstructor Led
Public Price$1125.00

DESCRIPTION (Return to Top)

This course introduces the attendee to the new SQL, application and XML features of DB2 9 for z/OS. 

AUDIENCE (Return to Top)

This course is intended for application developers, database administrators, DB2 system programmers and application architects.

OBJECTIVES (Return to Top)

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 (Return to Top)
  • 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
  • Programming Language Support for DB2 XML
  • XML Schemas, Validation and XML Schema Repository (XSR)


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.