G564 DB2 Stored Procedures

Course Code: G-564
Recommended Duration: 2 Days

Benefits

The student will learn how to develop stored procedures in DB2, as well as how to invoke stored procedures from a host-based application.

Audience

Application developers who need to create or invoke DB2 stored procedures written in COBOL, Assembler, PL/I, C/C++, or REXX.

Prerequisites

The student should have experience with basic SQL, as well as experience in doing DB2 application development..

Related IBM Materials

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

Major Topics Include

Exercises

There are five machine exercises and one optional exercise.

Special Note

Lecture notes include examples in COBOL, PL/I, C, Assembler, and REXX. Currently the labs are set up only for COBOL and C (with one optional exercise in REXX). If desired, we can add labs in PL/I or Assembler, but we need to know your requirements.

Course Description