Know Db2

Db2 for z/OS - Native and External Stored Procedures

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.

Topics Covered:

Duration: 3-days of lecture and Hands-on labs.

Audience: Application Developers and staff who will develop and implement Stored Procedures (SPs) for the Db2 environment.

Db2 for z/OS Native and External Stored Procedures Class Outline:

Stored Procedures Environment

  • 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
  •  

Parameter style Stored Procedures

  • 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 procedures
  • Hands-on Workshop
  •  

Result Set Stored Procedures

  • 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
  •  

Complex Stored Procedures

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

Distributed SQL Procedures Environment

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

Native Stored Procedures

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

SQL Procedures Language

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

Calling Stored Procedures from Remote Clients

  • Calling Stored Procedures
  • -WebSphere Application Server Java
  • -Problem Determination
  • DRDA support
  • Performance Considerations
  • Application Considerations
  •  

Tools for Stored Procedures

  • Data Studio
  • -Getting Started
  • -Working with Existing Stored Procedures
  • -Guidelines
  • Optim Development Studio
  • -Overview
  • -Related Products
  •  
  • ©2017 Computer Business International, Inc.

 

 

Would you like to schedule or customize this class?
Please call our toll free number (866-224-4968) or email us at info@cbi4you.com.