Db2 for z/OS: Using Stored Procedures

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.

Prerequisites

A working knowledge of Db2 is essential.

Duration

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

DBSP

Contents

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.