DB2 for z/OS Stored Procedures Workshop

Description

This course provides detailed coverage of the development of Stored Procedures for IBM's DB2 UDB for z/OS and OS/390 database management system. It is intended for application analysts and programmers and anyone involved in the setup and development of Stored Procedures. The course includes practical exercises.

Duration

3 days

Course Outline

1 Stored Procedures Overview
 - What are Stored Procedures?
 - Schemas.
 - Defining Stored Procedures.
 - Invoking Stored Procedures.
 - Parameters and Result Sets.
 - Stored Procedures Address Spaces.
 - Security.

2 Developing Stored Procedures
 - CREATE PROCEDURE Statement.
 - Coding a Stored Procedure.
 - Preparing a Stored Procedure.
 - Stored Procedure Package.
 - Linkage Conventions.
 - Passing LOB Locators.
 - Passing Transition Tables.
 - Returning Result Sets.
 - Accessing non-DB2 Resources.
 - Calling Other Programs.
 - WLM Controlled and DB2 Controlled Address Spaces.
 - LE and RRSAF.
 - ALTER PROCEDURE Statement.

3 Invoking Stored Procedures
 - CALL Statement.
 - Accessing Result Sets.
 - Preparing the Calling Program.
 - Calling Remote Stored Procedures.

4 COBOL, PL/1 and C Stored Procedures
 - Linkage Conventions. For General, General With Nulls, and DB2SQL Parameter Styles.
 - Reentrant Procedures.
 - Main or Subprogram?
 - Preparation.

5 SQL Stored Procedures
 - Supported Statements.
 - Coding.
 - Returning Result Sets.
 - Preparation.

6 Java Stored Procedures
 - Complied Java and Interpreted Java.
 - JDBC and SQLJ.
 - Defining and Coding.
 - Returning Result Sets.

7 REXX Stored Procedures
 - Coding.
 - Returning Result Sets.

8 Controlling Stored Procedures
 - WLM Controlled SPAS.
 - DB2 Controlled SPAS.
 - Commands.

9 Using the Stored Procedure Builder
 - Overview.
 - Concepts and Terminology.
 - Creating a Project.
 - Creating a Procedure.

10 Workshops
 - Basic Procedure.
 - Result Sets.
 - Remote Procedure.
 - SQL Procedures.
 - Using Stored Procedure Builder.