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

Course information: G-564 / 2 Days   These Materials © Copyright 2007 by Hunter Cobb    V2.x

Course Objectives
Course description
Home page

this page last updated: 11 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.