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:
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.
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