Course Description

DB2 Stored Procedures

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

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.

IBM Materials Required

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

• DB2 stored procedure architecture
• Stored Procedure Address Spaces
• Defining stored procedures
• CREATE PROCEDURE, ALTER PROCEDURE, DROP PROCEDURE
• Stored procedure catalog tables
• Writing stored procedures
• Parameter styles: GENERAL, GENERAL WITH NULLS, and DB2SQL
• Invoking stored procedures
• Preparing stored procedures and their invokers for execution
• DB2 Commands for stored procedures
• Returning result sets
• Accessing result sets
• Dynamic SQL in stored procedures
• ODBC and stored procedures
• SQL procedures language
• Stored procedure builder overview
• REXX and stored procedures

Exercises

There are five machine exercises and one optional exercise.

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.