This 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.
Students should have attended the Db2 for z/OS SQL & Application Programming class or equivalent and have a Working knowledge of COBOL and SQL.
4 Days/Lecture & Lab
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.
- Introduction to Stored Procedures
- External COBOL Stored Procedures
- Native SQL Procedure Language (SQL PL) Stored Procedures
- Global Temporary Tables
- Stored Procedure Performance