DB2 Stored Procedures

Course Number:  618-TF
Recommended Duration:  2 days

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

Course Overview
This course explores how to code and use SQL-based code that can be requested from the host and run on the client.

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

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

Topics

• 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