DB2 UDB Stored Procedures
 

This 3 day course is intended for:

System Administrators, Data Base Administrators and Lead Application designers who will be administering or writing stored procedures in DB2 UDB.

Topics Covered:

• DB2 UDB Stored Procedures for z/OS and OS/390
• 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
• Distributed SQL Procedures Environment
• SQL Procedures Language
• Calling Stored Procedures from Remote Clients
• Stored Procedures Builder

Objectives:

After completion the attendee should understand how to:

• Plan and implement stored procedures
• Develop and test cross platform Stored Procedures

Duration: 3 days

Delivery: Class Lecture and Hands-on Labs

Audience: 

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

Prerequisites:

Working knowledge of DB2 for z/OS or OS/390

Outline

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

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

4. Accessing Non-DB2 Resources

Software Prerequisites
RRSAF interface
Accessing non-DB2 resources
Coding Examples
Hands-on Workshop (optional)

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
Paper Workshop

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
References