July 18th - Phila - DB2 UDB for z/OS Application Programming Workshop

Cathy Peck

July 18th - Phila - DB2 UDB for z/OS Application Programming Workshop

Hi all, Larry asked me to forward this info to the RUG. If interested,
please contact Larry. (Some of you may recall Larry from when he taught an
Index class here a year back.). Please pass along to anyone you think might
be itnerested. Tks. Seeya!

To: Central PA RUG
From: Larry Kintisch [login to unmask email]

Subject: Upcoming IBM class in Philadelphia: CF820 DB2 UDB for z/OS
Application Programming Workshop

I’ll be the instructor for a summer class at Suburban Station [One Penn
Center] in Philadelphia from July 18 – 20, 2005, hosted by Jack Morton
Technical Education Group [formerly Right Source]. Call them at

This workshop assumes that a programmer who uses COBOL or PL/I has learned
SQL but needs to develop skills in embedding SQL into a z/OS program and
completing the program preparation cycle. This would be ideal for new
college hires that have limited z/OS and TSO skills or staff moving to DB2
from other platforms such as VSAM.

Below is the IBM course description. Hope to see you in Philadelphia!

CF820 DB2 UDB Application Programming Workshop

Public Price: $1,575

Acquire the skills necessary to produce application programs that
manipulate DB2 databases. Emphasis is on embedding Structured Query
Language (SQL) statements and preparing programs for execution.

Course Materials

The course materials cover DB2 UDB for z/OS Version 8.

Hands-On Labs

Eight labs are included to address application programming and preparation
using DB2 UDB for z/OS Version 8.


Prepare for IBM Certification Test 703: DB2 UDB V8.1 Family Application

Training Path

This course is part of an IBM Training Path. Taking this course in the
recommended sequence allows you to maximize the benefits from your

For this course's relationship to other courses in the DB2 Family:


For this course's relationship to other courses in DB2 UDB for z/OS and


IBM Education Advantage Program eligibility:

· Yes - IBM Education Card
· Yes - IBM Education Pack
· Yes - IBM Corporate Education Pass
· Yes - IBM Education Pack - online account

This is an intermediate course for application programmers who need to
write embedded SQL programs in Common Business Oriented Language (COBOL) or
Programming Language One (PL/I).

Skills Taught:
· Incorporate static SQL statements in an application program
· Prepare the program for execution
· Validate execution results are correct
· Produce code to support multiple rows being returned from the
database manager using cursors
· Identify considerations regarding units of work, concurrency, and
restart of programs
· Identify differences between static and dynamic SQL
· Provide test data for applications
· Discuss program and DB2 options relative to performance of static SQL
Course Outline:

DB2 concepts

· identify DB2 family products
· explain DB2 workstation component functions
· identify DB2 objects
· identify the key differences between static SQL and other application
alternatives for accessing DB2 data

Program structure I

· embed INSERT, UPDATE, DELETE and single-row SELECT statements in
application programs
· effectively communicate with DB2 when processing NULL values and
determining the success of statement execution
· demonstrate use of DB2 coding aids
· code CONNECT statements within an application program
· identify connection types and impacts on a unit of work

Program preparation

· identify the additional steps necessary to prepare a program that
contains embedded SQL for execution
· describe the functions of the DB2 PRECOMPILE and BIND processes
· describe factors relevant to the BIND process, including RUNSTATS
positioning, package status, parameters, and authorization requirements

Program structure II

· use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle
select criteria that may return multiple rows in application programs
· issue positioned UPDATE and DELETE statements
· identify how scrollable cursors can be used (z/OS)

Recovery and locking concepts

· define a unit of recovery
· identify the basic locking strategies used by DB2

Dynamic SQL introduction

· describe the difference between static and dynamic SQL
· list the types of dynamic statements
· code dynamic SQL in a program

Managing test data

· identify methods to insert data into a table
· use the LOAD or IMPORT utility
· identify the purpose of the RUNSTATS utility
· identify the purpose of the REORG utility

Performance considerations

· use programming techniques that enhance DB2 application performance
by following general guidelines, using indexable predicates, and avoiding
unnecessary sorts
· identify the access paths available to DB2
· list common causes of deadlocks and avoid such causes when possible
· use the EXPLAIN tools as aids to develop applications that emphasize