Course Description

Advanced DB2 Application Programming

This course: course objectives; course outline
Other links: 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 (scalar and table)
Dynamic SQL
Call Attachment and Recoverable Resource Services Attachment Facilities
The ODBC Interface
REXX and DB2
Native SQL stored procedures and user defined functions
XML and DB2
Locking and performance considerations
Extended indicator variables

Exercises

There are 23 machine exercises.

Course Objectives
Topical Outline
Home page

This page last updated: 1 August, 2014
This page copyright © 2014 by Hunter's Training Associates, LLC
This course copyright © 2013 by Hunter Cobb