DESCRIPTION
This 2-day course presents coding and administration requirements to implement DB2 Stored Procedures for the DB2 z/OS environment.
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 be able to:
- Describe 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 a Stored Procedure Calling Program
- Understand about Global Temporary Table
- Understand the major Performance Considerations for DB2 z/OS Stored Procedures
TOPICS
- Introduction to Stored Procedures
- Parameter Passing Stored Procedures
- Result Set Passing Stored Procedures
- Temporary Tables
- Stored Procedures Performance Considerations
PREREQUISITES
DB1010 DB2 for z/OS SQL & Application Programming.
Working knowledge of Cobol and SQL.
