< Previous | Next >

Setting up your environment

In this first exercise, you will access the IBM SQL and Routine Development perspective and view data preferences. The IBM SQL and Routine Development perspective in the workbench is where you do all of your work in this tutorial.
The IBM SQL and Routine Development perspective consists of several default views, including: As with any perspective in the workbench, you can customize the IBM SQL and Routine Development perspective to include other views or exclude these or other default views.

In this tutorial you will use the IBM SQL and Routine Development 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. Access the IBM SQL and Routine Development perspective.
    • If the perspective is open in the workbench but not active, return to the perspective. Click the Arrow button button in the top-right corner of the workbench and then select IBM SQL and Routine Development.
    • If the perspective is not open in the workbench, open the perspective:
      1. Click Window > Open Perspective > Other from the main menu bar.
      2. In the window that opens, select IBM SQL and Routine Development, and then click OK.
      The IBM SQL and Routine Development perspective opens with the default views.
    If you have not created any data projects previously, the Data Project Explorer is empty. In a later lesson, you will create a data development project that will be displayed in the Data Project Explorer. If you have set up the GSDB sample database, you should see an offline connection to it in the Data Source Explorer. In a later lesson, you will set up a connection to the GSDB database, so for now just notice where the database connections are displayed in the Data Source Explorer.
  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. For now, keep the defaults.
    3. Back in the list of preferences pages, expand the Data Management node, then expand the SQL Development node, and then expand the Routines node. There are several preferences pages that are associated with data development. View the pages under the Routines 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 Data Source 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 expand the Routine Debugger node, and then click IBM to see the available options for stored procedure debug. In a later exercise, you will modify these preferences. For now, keep the defaults.
    5. Click OK to close the Preferences window.
< Previous | Next >
Feedback