On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB1020 Stored Procedure Options on DB2 for z/OS
Duration3 Days
Delivery MethodInstructor Led, Hands-on workshops
Public Price$1625.00

DESCRIPTION (Return to Top)

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 (Return to Top)

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 (Return to Top)

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 (Return to Top)
  • Introduction to Stored Procedures
  • External COBOL Stored Procedures
  • Native SQL Procedure Language (SQL PL) Stored Procedures
  • Global Temporary Tables
  • Stored Procedure Performance


DB1010 DB2 for z/OS SQL & Application Programming. Working knowledge of COBOL and SQL.