Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.


Course Skill Level:


Course Duration:

3 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:


  • Course Code:


Who should attend & recommended skills:

Application developers & staff with basic COBOL & Db2 for Z/OS SQL & application programming skills

Who should attend & recommended skills

  • Application Developers and staff who will develop and implement Stored Procedures (SPs) for the Db2 environment
  • Db2 for z/OS SQL and Application Programming: Basic (1-2 years’ experience) or course
  • COBOL and SQL: Basic (1-2 years’ experience)

About this course

This 3-day hands-on course concentrates on methods to develop, implement, tune and test Native and External Stored Procedures in a Db2 z/OS Environment.

Skills acquired & topics covered

  • Stored Procedures Environment
  • Methods for Coding and Testing simple COBOL Parameter Style Stored Procedures
  • Coding and Testing COBOL Result Set Stored Procedures
  • Accessing Non-Db2 Resources from a COBOL Stored Procedure
  • SQL Procedures Language
  • Calling Stored Procedures from Remote Clients
  • Native Stored Procedures
  • Tools

Course breakdown / modules

  • Review of Stored Procedure Flow in Db2
  • External, SQL PL, Native, Remote SPs
  • Architecture and Resources
  • Db2 Catalog Tables in SPs
  • Db2 Stored Procedures and WLM
  • Implementation and Administration
  • RRSAF with SPs
  • Examples of Defining Stored Procedures

  • Developing the Stored Procedure
  • Example Stored Procedure program
  • Preparation Procedures
    • Defining the Stored Procedure
  • Calling the Stored Procedure
    • Coding Rules
    • Example program
    • Preparing and testing procedures
  • Hands-on Workshop

    • Developing the Stored Procedure
      • Coding Rules
      • Example Stored Procedure program
    • Preparation Procedures
      • Defining the Stored Procedure
      • Calling the Stored Procedure
    • Coding Rules
      • Example Program
      • Preparing and testing
    • Hands on Workshop

    • Accessing Non-Db2 resources
      • Software Prerequisites
      • RRSAF interface
      • Coding Examples
    • Using Global Temporary Tables
    • Scrollable Cursors
    • Hands on Workshop

    • Remote Stored Procedures
      • DRDA Architecture
      • Db2 Connect Overview
      • Db2 Products
    • Developing Stored Procedures
      • Recent Enhancements
      • Implementation

    • Developing Stored Procedures
    • Performance Savings
    • Examples of Native Stored Procedures
    • Coding Requirements
    • Recent Enhancements
    • Implementation
    • Hands-on Workshop

    • What are SQL Stored Procedures
    • Procedures Body
      • Compound Statements
      • Variable Declarations
      • Handling Errors
      • Basic Control Statement
      • Assignment Statement
    • SQL Allowed
    • Examples
    • Paper Workshop

    • Calling Stored Procedures
      • Web Sphere Application Server Java
      • Problem Determination
    • DRDA Support
    • Performance Considerations
    • Application Considerations

  • Data Studio
    • Getting Started
    • Working with existing Stored Procedures
    • Guidelines
  • Optim Development Studio
    • Related Products