On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:
DB1095 DB2 9 for z/OS Application & XML Features
 
Request a Course using our convenient on-line form, or Call 800.756.3000 to schedule a class in your area.
Full Course Description
 
Duration 2 Days
  Delivery Method Instructor 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
  • SELECT with XMLQUERY
  • WHERE with XMLEXISTS
  • Programming Language Support for DB2 XML
  • XML Schemas, Validation and XML Schema Repository (XSR)

PREREQUISITES (Return to Top)

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.