< Previous | Next >

Setting up your environment

In this first exercise, you will open the Data perspective and view data preferences. The Data perspective in the workbench is where you do all of your work in this tutorial.

The Data perspective consists of several default views, including: As with any perspective in the workbench, you can customize the Data perspective to include other views or exclude these or other default views.

In this tutorial you will use the Data perspective default views.

If you are new to the Eclipse workbench, refer to the workbench tutorial for detailed information about how to set up and use Eclipse views and perspectives.

To set up your environment:

  1. Open the Data perspective.
    1. Click Window > Open Perspective > Other from the main menu bar.
    2. In the window that opens, select Data, then click OK. If you do not see Data in the list, click Show all.
    The Data perspective opens with the default views. If you have not previously created any data projects, the Data Project Explorer is blank. In a later lesson, you will create a data development project that will be displayed in the Data Project Explorer. In the Database Explorer, expand the Connections folder. In the Database Explorer contains a connection to the Derby 'sample' database, which is included with this product.If you have the DB2 SAMPLE database set up, you should see an offline connection to it in the Database Explorer. In a later lesson, you will set up a connection to the SAMPLE database, so for now just notice where the database connections are displayed in the Database Explorer.
    Screen capture showing the Database Explorer with the Derby SAMPLE database connection as described in the last steps.
  2. View data preferences. You can customize the workbench settings for database development in the Preferences window. In this tutorial, you will view preferences but you will not change them.
    1. Click Window > Preferences from the main menu bar.
    2. Expand the General node and view the preferences pages in this node. You can use these pages to set preferences for appearance, editors, and other general settings. In this case, you keep the defaults.
    3. Back in the list of preferences pages, expand the Data node, then expand the Stored Procedures and User-Defined Functions node to see the available options. There are several preferences pages that are associated with data development. View the pages under the Stored Procedures and User-Defined Functions node to see available options. For each type of routine, you set deploy and debug preferences on these pages. In this tutorial, you do not need to modify any preferences.
      Screen capture showing the Database Explorer with the Derby SAMPLE database connection as described in the last steps.
    4. Back in the list of preferences pages, expand the Run/Debug node, then click DB2 Stored Procedure Debugger to see the available options for stored procedure debug. In a later exercise, you will modify these preferences. For now, you keep the defaults.
    5. Click OK to close the Preferences window.