IBM DB2 9 Database System Application Developer Professional Training Workshops

Course code: CL100
Skill level: Basic
Duration: 3 days
Delivery type: Classroom (Hands-on labs)

This course enables you to 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.

Audience

This basic course is for application programmers who need to write embedded SQL programs in COBOL or PL/I (on z/OS) or in C language (on Linux, UNIX, and Windows).

Prerequisites

You should have experience with one of the supported programming languages, COBOL or PL/I for z/OS, or C language for Linux, UNIX, and Windows. You are also expected to already be able to construct and use SQL statements.

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

Please refer to the course overview for description information.

Course code: CL110
Skill level: Advanced
Duration: 2 days
Delivery type: Classroom (Hands-on labs)

This is the Classroom version of Instructor-led online course DB2 9 for Linux, UNIX and Windows Application Programming Advanced (ILO) (3L110).
This course teaches how to take advantage of advanced programming techniques to access DB2 databases in the workstation environment. These techniques can be utilized in addition to standard embedded SQL calls that are addressed in the prerequisite offering,DB2 UDB Programming Fundamentals.
These advanced techniques include:
Stored Procedures
User-Defined Functions
Application Programming Interfaces (APIs)
Performance concepts are also addressed.

Audience

This advanced course is for application programmers and other technical personnel who are involved in designing and implementing applications that access DB2 data from a workstation environment.

Prerequisites

The following prerequisites are suggested:
The ability to code embedded, static SQL applications
Familiarity with relational database concepts
Use of basic C language syntax components

These skills can be developed by taking:
Introduction to C Programming
DB2 UDB Programming Fundamentals
Equivalent experience may be substituted for these courses.
Application programming experience with other relational database systems, such as DB2 MVS, DB2/VSE and VM, and DB2/400, would be appropriate for meeting the DB2 prerequisites.

Skills taught

Use object-relational capabilities of DB2 UDB such as LOB manipulation, user-defined functions, and user-defined distinct types
Code stored procedures and call such procedures
Use product-defined Application Programming Interfaces (APIs)

Data Quality Issues
QualityStage Architecture
Developing with QualityStage
Investigation
Standardize
Match
Survivorship
Reference Match