Public Class
DB2 UDB Stored Procedures
 

Attend this two day course prior to implementing, developing and testing cross platform Stored Procedures for the DB2 UDB environment.  The first day of the course concentrates on developing DB2 UDB for z/OS and OS/390 stored procedures.  The second day of the course addresses SQL procedures and the distributed environment.

Call toll-free to register! (866)CBI-4YOU  (866)224-4968

DB2 UDB Stored Procedures

This course presents the coding and administration requirements to implement, develop and test cross platform Stored Procedures for the DB2 UDB Environment. The first day of the course concentrates on developing DB2 UDB for z/OS and OS/390 stored procedures. The second day of the course addresses SQL procedures and the distributed environment.

Topics Covered:

• Stored Procedures Environment
• 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
• Stored Procedures Builder

Duration  Two,  one-day Lectures

Audience: DBAs and Application Developers who will develop and implement Stored Procedures for the DB2 UDB environment.

OUTLINE:  DAY 1

1.  Stored Procedures Environment

• What are Stored Procedures?
• Software Prerequisites
• Stored Procedures Architecture
• Environment setup requirements
• DB2 private Stored Procedures vs. WLM Stored Procedures
• Implementation and Administration

2.  Simple 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

3.  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

4.  Complex Stored Procedures

• Accessing non-DB2 resources
• Software Prerequisites
• RRSAF interface
• Coding Examples
• Using Global Temporary Tables
• COMMIT & ROLLBACK
• Using SAVEPOINTs
• Scrollable Cursors

OUTLINE: DAY 2

5.  Distributed SQL Procedures Environment

• Distributed Processing
  DRDA Architecture
  DB2 Connect Overview
  DB2 Products
• Developing Stored Procedures
  Recent Enhancements
  OS/390 Implementation
  Intel & UNIX Implementation

6.  SQL Procedures Language

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

7.  Calling Stored Procedures from Remote Clients

• Calling Stored Procedures
  CLI & ODBC Applications
  WebSphere Application Server Java
  Problem Determination
• DRDA support for 3-part Names
• Performance Considerations
• Application Considerations

8.  Stored Procedures Builder

• Stored Procedures Builder
  Getting Started
  Working with Existing Stored Procedures Guidelines
• Demo Walk-thru