Db2 for z/OS: Using Stored Procedures

This one-day course is a comprehensive introduction and explanation of the use of Stored Procedures in a Db2 for z/OS environment.
This course is available 'on demand' (minimum 2 students) for public presentations or for one-company, on-site presentations.

What you will learn

On successful completion of this course you 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.


A working knowledge of Db2 is essential.


1 day

Fee (per attendee)

£660 (ex VAT)


This includes free online 24/7 access to course notes.


Hard copy course notes are available on request from rsmshop@rsm.co.uk

at £50.00 plus carriage per set.

Course Code



Introduction to Stored Procedures

What is a stored procedure?; using stored procedures in a client/server environment; examples of stored procedures; external stored procedures; external SQL procedures; native SQL procedures; .

Stored Procedure Environment

Stored procedure address space; establishing the environment; identifying the environment to the procedure.

Writing and Preparing External Stored Procedures

External stored procedures; language requirements; writing stored procedures; commit and rollback processing; returning results sets; preparing and binding stored procedures.

Writing and Preparing SQL Procedures

External SQL procedures; native SQL procedures; SQL procedural language; SQL procedure body; compound statements; parameters & variables; handling conditions; preparing SQL procedures; debugging SQL procedures.

Defining Stored Procedures to Db2

The CREATE PROCEDURE statement and options.

Writing and Preparing the Calling Application

The CALL statement; passing parameters; parameter styles; preparing the application; identifying the procedure.

© RSM Technology 2022