DB2 for z/OS: Using Stored Procedures

Objectives
On successful completion of this course, attendees will be able to:

• describe DB2 Stored Procedures at a conceptual and practical level
• write and prepare DB2 Stored Procedures
• use DB2 Stored Procedures.

Who Should Attend
Anyone requiring a complete and thorough introduction to DB2 Stored Procedures, whether involved in DB2 application development, database administration, operational and technical support, or system administration.
Prerequisites
A working knowledge of DB2 is essential.
Duration
1 day

Course Code
DBSP
Contents
Introduction to Stored Procedures
What is a Stored Procedure?; using Stored Procedures in a client/server environment; examples of Stored Procedures; types of Stored Procedures.


Stored Procedure environment
Stored Procedure address spaces (DB2 & WLM); defining SPAs; Stored Procedure definition options.


Writing and Preparing External Stored Procedures
External Stored Procedures; SQL procedures; language requirements; writing Stored Procedures; preparing & binding Stored Procedures; writing & preparing applications to use Stored Procedures.


Writing & Preparing SQL Procedures
SQL procedure body; compound statements; parameters & variables; handling conditions; preparing SQL procedures.


Defining Stored Procedures to DB2
CREATE PROCEDURE statement and options.


Writing & Preparing the Calling Application
CALL statement; passing parameters; parameter styles; preparing the application; identifying the procedure.