DB2 Stored Procedures
Overview

This course presents the use of Stored Procedures as a solution to specific application needs in a Client / Server environment. The IBM DB2 Stored Procedure Builder product is used as the tool to build these Stored Procedures.

The use of the CALL statement is presented as the means to invoke a Stored Procedure. Various methods for debugging a Stored Procedure are also presented.

The IBM DB2 Stored Procedure Builder is used in class exercises for creating, modifying and debugging procedures in both SQL/PL and JAVA. This course covers the coding Stored Procedures in DB2 SQL Procedure Language (SQL/PL) and Java.

Several hands-on exercises demonstrate the use of INPUT and / or OUTPUT parameters and internal Stored Procedures logic.

Several "complex" DB2 Stored Procedures are reviewed as an insight into examples of the capabilities of Stored Procedures.

Data Definition Language (DDL) is used as another method to create Stored Procedures.

Workshop exercises run on a Windows workstation. These exercises are applicable to coding of SQL/PL or Java Stored Procedures using the Development Center or other development products (such as RapidSQL) on all IBM DB2 platforms.

LEARNING OBJECTIVES

Upon successful completion of this course, the student will be able to -

  • Describe what a stored procedure is and how it works
  • Describe the capabilities of the DB2 Stored Procedure Builder
  • Describe various DB2 SQL/PL statements and how to use them in an application
  • Describe the basic structure of a Java application using Stored Procedures
  • Create DB2 Stored Procedures using the SQL DDL statement - CREATE PROCEDURE
  • Debug Stored Procedures
Audience

Database application designers and application programmers who need to build, test, and modify DB2 Stored Procedures.

Prerequisites

The student must have at least 6 months experience with both SQL and the Windows environment.

Course duration

2 days

Course outline

DAY 1
 
  1. Stored Procedure overview
  2. DB2 SQL Procedure Language (SQL/PL)
  3. IBM DB2 Stored Procedure Builder - SQL
  4. BM DB2 Stored Procedure Builder - Java
DAY 2
 
  1. CALLing a DB2 Stored Procedure
  2. The CREATE PROCEDURE DDL statement
  3. Stored Procedure Debugging


Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2002 Wintrac Inc.