DB2 Native SQL Stored Procedures - Topical Outline

Overview of native SQL stored procedures

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

DB2 Commands for native SQL stored procedures

Deploying native SQL stored procedures

Catalog changes for native SQL stored procedures

G531 / 1 Day

These Materials © Copyright 2013 by Hunter Cobb

Materials version: V1.x

Course Objectives
Course Description
Home page

This page last updated: 1 August, 2014
Copyright © 2014 by Hunter's Training Associates, LLC