DESCRIPTION
This 3-day course presents coding and administration requirements for implementing DB2 Stored Procedures on DB2 for z/OS. Both external (COBOL)and native SQL Procedure Language Stored Procedures are covered.
AUDIENCE
Database Administrators and Application Developers who will be setting up the Stored Procedures environment on the DB2 for z/OS platform as well as calling and/or coding stored procedures in the DB2 z/OS environment.
OBJECTIVES
Upon successful completion of this course, the student will:
- Understand the Stored Procedures Environment and setup requirements to implement stored procedures
- Be able to code and test DB2 for z/OS Stored Procedures using COBOL
- Code and test a Stored Procedure Calling Program
- Be able to use IBM Data Studio to code an SQL PL Stored Procedure
- Understand the two types of Global Temporary Tables and their use with Stored Procedures
- Understand the major Performance Considerations for DB2 z/OS Stored Procedures
TOPICS
-
Introduction to Stored Procedures
-
External COBOL Stored Procedures
-
Native SQL Procedure Language (SQL PL) Stored Procedures
- Global Temporary Tables
- Stored Procedure Performance
PREREQUISITES
DB1010 DB2 for z/OS SQL & Application Programming.
Working knowledge of Cobol and SQL.
