Before you start
This tutorial takes a basic approach to working in the Eclipse environment, starting by explaining user interface concepts and offering steps for completing basic database programming tasks.
In this tutorial, learn how the DWB resources, perspectives, views, editors, and wizards assist you to work with databases, routines, SQL statements, and data. After completing this tutorial, you should be familiar with concepts such as the Data perspective, the Database Explorer view, the Database Project Explorer view, the Database Output view, the SQL Builder wizard, the SQL Editor, and the Table Editor.
You must install and configure the SAMPLE database with the XML options that is included with DB2 V9.1. See the DB2 product documentation and First Steps for more information.
To run the examples in this tutorial, you need to install DB2 V9.1 and the SAMPLE database with the XML options. 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.