Course Description

DB2 Version 5 to Version 7 Transition for Developers

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

Benefits

The student will learn what has changed in DB2 Versions 6 and 7, what has been added in these releases, and how the changes affect the activities that are associated with DB2.

Audience

Application developers who will be involved in migrating, developing, maintaining, or enhancing systems that will operate under DB2 Version 7.

Prerequisites

The student should be knowledgable of the features of the DB2 Data Base Management System that are relevant for application development.

Related IBM Materials

This course is drawn from these IBM manuals; access to them in the classroom is desirable but not required:

SC26-9013 - DB2 Version 6 Release Guide

SC26-9923 - DB2 Version 7 Release Guide

• EXPLAIN, PLAN_TABLE, and DSN_STATEMENT_TABLE changes
• New and changed SQL statements and built-in functions
• Savepoints
• UNION in views
• Declared global temporary tables
• Scrollable cursors, sensitive and insensitive
• BIND changes
• Stored procedures enhancements
• New data types: ROWID and identity columns
• Triggers
• DB2 Extenders: Image, Audio, Video, Text, and XML

Exercises

There are five exercises.