Db2 for z/OS COBOL Stored Procedures

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: DB1025

Audience

Database Administrators and Application Developers who will be setting up and defining Stored Procedures on a Db2 for z/OS platform as well as anyone who will be coding the stored procedures. There are both coding workshops for the stored procedures, and COBOL calling programs.

Description

This 2-day course presents coding and administration requirements to implement COBOL Db2 Stored Procedures for the Db2 z/OS environment. Students will leave this class with a full understanding of what is takes to code and implement a stored procedure. Time is spent on the stored procedure definitions, along with creating, coding, and implementation steps needed. Hands on workshops for all the steps needed are part of the class.

Objectives

Upon successful completion of this course, the student will be able to:

Understand the Stored Procedures Environment and setup requirements to implement stored procedures
Code and test Db2 for z/OS Stored Procedures using COBOL
Code and test Stored Procedure Calling Programs
Understand the use of Global Temporary Table
Understand the major Performance Considerations for Db2 z/OS Stored Procedures

Prerequisites

Working knowledge of both COBOL and SQL.

Topics

I. Introduction to Stored Procedures
- Client/Server Processing
- Stored Procedures
- Architecture
- Installation Considerations
  - WLM-Established Stored Procedures Address Spaces
  - Stored Procedures
  - Parameters Panel: DSNTIPX
  - Enabling Stored Procedures after Installation
- Tasks for Using Stored Procedures
- Stored Procedures Run-time Environment
- Administrator Tasks
- Using Commands
- Obtaining Diagnostic Information
II. Parameter Passing Stored Procedures
- An Example of a Simple Stored Procedure
- Tasks for using Stored Procedures
  - Writing and Preparing Stored Procedures
  - Invoking Stored Procedures
  - Defining Your Procedure to Db2
- Calling Simple COBOL Stored Procedures
III. Result Set Passing Stored Procedures
- Improved Functionality with Result Sets
- Requirements for Returning Result Sets
- How to Write Applications That Receive Result Sets
IV. Temporary Tables
- Global Temporary Tables
  - Created Temporary Tables
  - Declared Temporary Tables
- Using Temporary Tables to Hold Result Sets
- Coding Example: Declared Global Temporary Table
V. Stored Procedures Performance Considerations
- Coding Efficient Stored Procedures
- Managing the WLM Environment
- Managing the Db2 Environment
- Network Issues