 | Level: Introductory Debra R. Eaton (deaton@us.ibm.com), DB2 Software Information Technology Specialist, IBM
14 Sep 2006 The IBM® DB2® Developer Workbench (DWB) gives DB2 9 database developers the ability to develop applications that access data. DWB is based on Eclipse technology, which replaces the Swing-based DB2 V8 Development Center. Learn how the DWB resources, perspectives, views, editors, and wizards assist you to work with stored procedures.
Objectives - Learn how the DWB resources, perspectives, views, editors, and
wizards assist you to work with stored procedures.
- Become familiar with tasks such as creating, debugging, editing,
deploying, running, exporting, deleting, and dropping a stored procedure.
Prerequisites
You must install and configure the SAMPLE database that is included
with DB2 V9.1. See the DB2 product documentation and First Steps for more information.
System requirements
To run the examples in this tutorial, you need to install DB2 V9.1 and
the SAMPLE database. You must be able to connect to the SAMPLE database
with a user ID and password. If your installation of DWB is new, your perspectives (Eclipse views) will be empty.
The figures used in this tutorial contain resources because the Workbench contained existing projects. Once you create a
project in this tutorial, your Workbench will contain similar resources. The schema used throughout this tutorial is "DEATON." Replace the "DEATON"
schema with your schema, represented in the instructions by SCHEMANAME
when a task requires a schema name.
Formats html, pdf
Tutorial overview
This tutorial takes a basic approach to working with stored procedures in the DWB Eclipse environment, starting by creating a simple stored procedure, followed by debugging, editing, deploying, and running the stored procedure.
| | | |
