 | Level: Introductory Debra R. Eaton (deaton@us.ibm.com), DB2 Software Information Technology Specialist, IBM
17 Aug 2006 The IBM® DB2® Developer Workbench (DWB) gives DB2 9 database developers the ability to develop database application objects that access data. DWB is based on Eclipse technology, which replaces the Swing-based DB2 V8 Development Center. Get an introduction to the Eclipse User Interface and basic data development tasks.
Objectives - Learn how the DWB resources, perspectives, views, editors,
and wizards assist you to work with databases, routines, SQL statements, and data.
- Become 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.
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 in the Eclipse environment, starting by
explaining user interface concepts and offering steps for completing basic
database programming tasks.
| | | |
