G564 DB2 Stored Procedures - Topical Outline

DB2 Stored Procedures - Topical Outline

Stored Procedure Overview

Stored Procedure Address Spaces

Defining Stored Procedures

CREATE PROCEDURE

ALTER PROCEDURE

DROP PROCEDURE

Language Environment Run-time Parameters

Stored Procedure Catalog Tables

Computer Exercise: Defining Stored Procedures

Writing Stored Procedures

Parameters

Null Values

Program Types: MAIN and SUB

COMMIT and ROLLBACK

Non-DB2 Resources

Invoking Stored Procedures

Null Values

Calling Literals vs. Calling Variables

Preparing Stored Procedures and their Invokers

Activating Stored Procedures

Computer Exercise: Writing, Preparing, and Executing Stored Procedures

Returning Result Sets

Result Sets from the Caller’s Perspective

Testing Stored Procedures

Computer Exercise: Stored Procedures with Result Sets

Dynamic SQL in Stored Procedures

PREPARE / OPEN

SQLDA

Dynamic SQL in Callers of Stored Procedures

Quasi-dynamic EXEC SQL CALL

Dynamic ASSOCIATE LOCATORS

Dynamic ALLOCATE CURSOR

DESCRIBE PROCEDURE

DESCRIBE CURSOR

Retrieving Rows with an SQLDA

Computer Exercise: Using Dynamic SQL in Stored Procedures

ODBC and Stored Procedures

Defining ODBC Stored Procedures

Coding Stored Procedures that use ODBC

Invoking Stored Procedures from ODBC clients

Miscellaneous ODBC Functions

Preparing ODBC Stored Procedures and Invokers

Computer Exercise: Using ODBC in Stored Procedures

Stored Procedures in REXX

Calling Stored Procedures

Writing Stored Procedures

Handling Null Values

Working with Result Sets

Computer Exercise: REXX Stored Procedures

SQL Procedures Language

Stored Procedure Builder

G564 / 2 Days

Materials version: V2.x

Course Objectives
Course Description
Home page