Course Description

DB2: Greatest Hits

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

The student will be able to exploit many of the important new features introduced on DB2 for z/OS in Versions 8 and 9.

Audience

Experienced DB2 users that need to become familiar with the most important new features introduced in DB2 Versions 8 and 9, from an applications programmer perspective.

Prerequisites

The student should have experience in using ISPF/PDF, DB2, SQL, and SPUFI.

Related IBM Materials

Classroom access to a set of DB2 reference manuals is desirable but not required.

• 64-bit storage, Unicode, and zIIPs overview
• New SQL statements TRUNCATE and MERGE
• Common table expressions and recursive SQL
• OLAP functions
• Scrollable cursors
• Mulitple row SQL
• LOB file reference variables
• Native SQL stored procedures
• Sequence objects
• Clone tables
• Row change timestamps
• New data types
• New index features
• XML in DB2

Machine Exercises

There are six machine exercises.