DB2 Native SQL Stored Procedures - Course Objectives

On successful completion of this course, the student, with the aid of the appropriate reference materials, should be able to:

1. Understand the syntax of the SQL procedure language
2. Design and code native SQL stored procedures
3. Understand the options of the CREATE PROCEDURE, ALTER PROCEDURE, and DROP PROCEDURE statements for native SQL stored procedures
4. Use conditions, handlers, and compound statements in native SQL stored procedures
5. Use versioning in the creation and maintenance of native SQL stored procedures
6. Understand and use the commands associated with maintaining native SQL stored procedures.

G531 / 1 Day

These Materials © Copyright 2011 by Hunter Cobb

Materials version: V1.x

Topical Outline
Course Description
Home page

This page last updated: 23 November, 2011
Copyright © 2011 by The Trainer's Friend, Inc.