DB2 Refresher with DB2 Version 7 Differences

Course Number:  702-JK
Recommended Duration:  5 days

Intended Audience
Experience DB2 programmers who need to update their DB2 knowledge, both from a DB2I perspective, and from within application programs.

Course Overview
This course is a review and update of DB2 for experienced DB2 programmers.  Topics include coding SQL statements to access DB2 objects, both using SPUFI under DB2I, and from within application programs, and how to establish the appropriate execution environment for programs that reference DB2 Data Bases.  The changes in DB2 Version 5; what has been added in this release, and how the changes affect the activities that are associated with DB2.

Prerequisites
Students should have previous experience in designing and coding application programs using SQL.

Topics

• Relational database and DB2 concepts

• DB2I, SQL, and SPUFI

• SELECT

• UPDATE/DELETE/INSERT

• COMMIT/ROLLBACK

• Joins, Outer Joins, and Nested Queries

• Nested table expressions 

• Creating DB2 tables and views

• DB2 Objects and DB2 Catalog Tables

• SQL in application programs

• Host variables and structures

• DCLGEN and SQLCA

• BIND/REBIND/FREE

• Cursors and Locks

• Security and authorization

• EXPLAIN and efficiency considerations

• Query CPU parallelism 

• Stored procedures 

• Row level locking and type 2 indexes 

• Catalog indexes and utilities 

• Catalog table changes 

• Utility extensions