TTFlogo2.gif (2585 bytes)

Course Description

Advanced DB2 Application Programming

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

Course Code: G-562
Recommended Duration: 10 Days

Benefits

The student learns advanced programming techniques for accessing DB2 data, and acquires skills in assessing the performance of SQL statements.

Audience

Application programmers who need to be able to employ advanced tools to access DB2 data.

Prerequisites

The student should be skilled in coding basic SQL statements, and in embedding these statements in application programs.

Related IBM Materials

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

Major Topics Include

DB2 access strategies
EXPLAIN, PLAN_TABLE, and DSN_STATEMNT_TABLE
TRUNCATE, GET_DIAGNOSTICS, MERGE, SELECT from DML statements
OLAP functions
Joins, left, right, and full
Subqueries
UNION, INTERSECT, and EXCEPT
Nested table expressions
Common table expressions
Views
Application plans and packages
Remote Data Access
LOAD and UNLOAD utilities
DSNTEP2, DSNTIAUL, and DSNTIAD
Working with LOBs
External stored procedures
User-defined data types
User-defined functions
Dynamic SQL
Call Attachment and Recoverable Resource Services Attachment Facilities
The ODBC Interface
REXX and DB2
Native SQL stored procedures
XML and DB2
Locking and performance considerations

Exercises

There are 21 machine exercises.

Course Objectives
Topical Outline
DB2 curriculum
Complete topics list
Home page

This page last updated: 17 November, 2011
This page copyright © 2011 by The Trainer's Friend, Inc.
This course copyright © 2011 by Hunter Cobb