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.
A two-day version of this course is available for one-company, on-site presentations. This extended version includes many practical hands-on sessions, with exercises based on the customer's chosen environment (e.g. COBOL, PL/I, etc.).

This course is available 'on demand' (minimum 2 students) for public presentations or for one-company, on-site presentations.

Objectives

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)

£425 (ex VAT)

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.


© RSM Technology 2017