DB2 Native SQL Stored Procedures - Topical Outline

Overview of Native SQL stored procedurs
Defining Native SQL stored procedures
    CREATE PROCEDURE
    Parameter declarations
    Options
Removing stored procedure definitions
DROP PROCEDURE
    Computer Exercise: A Simple Native SQL Stored Procedure

Native SQL Procedures Language Syntax
SQL statements
Compound Statements
Comments
Labels
Declarations: Variable, Conditions, Handlers, and Cursors
Procedural Statements
    Computer Exercise: A more complicated native SQL stored procedure

ALTER PROCEDURE parameters
Versioning
    ADD VERSION
    ALTER VERSION
    REPLACE VERSION
    ACTIVATE VERSION
    REGENERATE VERSION
    DROP VERSION
        Computer Exercise: Converting a COBOL stored procedure to native SQL

Course information: G-531 / 1 Day   These Materials © Copyright 2009 by Hunter Cobb    V1.x

Course Objectives
Course description
Home page

this page last updated: 18 January, 2009
this page copyright © 2009 by The Trainer's Friend, Inc.