The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 Developer Workbench, Part 1: Developer Workbench concepts and basic tasks

Debra R. Eaton, DB2 Software Information Technology Specialist, IBM

Debra Eaton has worked in DB2 Technical Sales as a Software Information Technology Specialist on the DB2 Migration Team for 10 years. She specializes in converting customer applications from non-DB2 databases to DB2. She has authored IBM Redbooks, white papers, and DB2 Magazine articles on topics related to DB2 application development. In addition, she has presented these topics at IDUG and DB2 technical conferences.

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

View more content in this series

Date: 24 Oct 2006 (Published 17 Aug 2006)
Level: Introductory
PDF: A4 and Letter (3887 KB | 63 pages)Get Adobe® Reader®

Activity: 12289 views
Comments:

Before you start

About this tutorial

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.

Objectives

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.

Prerequisites

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.

System requirements

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.

Comments