Course Description

DB2 Application Programming

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

Benefits

Students who complete this course will be able to code SQL statements to access DB2 objects, both using SPUFI under DB2I, and from within application programs in the student's standard host environment - CICS, IMS/DB/DC, TSO, or batch. The student also learns how to establish the appropriate execution environment for programs that reference DB2 Data Bases.

Audience

COBOL, PL/I, C, or Assembler programmers who need to work with DB2 Databases, both from a DB2I perspective, and from within application programs.

Prerequisites

Experience designing and coding application programs in COBOL, PL/I, C, or Assembler in the application environment (CICS, IMS/DB/DC, TSO, or batch) in which DB2 will be used.

Related IBM Materials

DB2 Application Programming and SQL Guide  

DB2 SQL Reference  

• Relational database concepts
• DB2 concepts
• DB2I, SQL, and SPUFI
• SELECT / UPDATE / DELETE / INSERT
• COMMIT / ROLLBACK
• Joined and nested queries
• Creating DB2 tables
• DB2 objects
• DB2 system 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

Exercises

There are 12 machine exercises, and one optional machine exercise.

Note

This class is multi-lingual. Lecture examples are included in COBOL, PL/I, C, and Assembler; each student may run the labs in any of these languages.