Create, test, and deploy a DB2 SQL stored procedure - introduction

Learning objectives

This tutorial is divided into several exercises that you must complete in sequence. This tutorial teaches you how to create, test, and deploy a DB2 SQL stored procedure. While completing the exercises, you will:

Time required

To complete this tutorial, you will need approximately 1 hour and 45 minutes. If you decide to explore other facets of stored procedures while working on the tutorial, it could take longer to finish.

Prerequisites

In order to complete this tutorial end to end, you should be familiar with the following concepts:

You must install and configure the SAMPLE database that is included with DB2(R) Universal Database(TM). See the DB2 Universal Database documentation and First Steps for more information.

It will also help if you understand the following concepts:

When you are ready, begin Exercise 1.1: Setting up the environment for stored procedure development

Terms of use | Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.