This tutorial will show you how to view the source code of triggers using IBM Data Studio.

There are three options in IBM Data Studio called Activities from which you can view the code.

1. Administer Databases
2. Develop SQL and Routines
3. Tune Queries

You choose Activity in the toolbar:

The three activity options are described below.

The Administer Databases activity

The Administer Databases activity option displays database objects using a data approach, so they are classified into two main groups: databases and sets.

To view the code of a trigger, perform any of the following options.

Option 1

1. In the left pane of the screen that is displayed, expand the All Databases group and select the appropriate database to expand its objects tree, then select Triggers.
2. In the upper right pane, select the desired Trigger.
3. In the lower right pane, select the Details option to display the code.

Option 2

1. In the upper right pane, click in the last icon of the pictorial path to display a list of options, then select Triggers.

2. Again, in the upper right pane, select the desired trigger and in the lower pane select the Details option to display the code.

The Develop SQL and Routines and the Tune Queries activity options

These activity options display database objects using a development approach, so they are classified into two main groups: Configuration Repositories and Database Connections.

Because both activities have the same options, they share the same steps described below.

To view the code of a trigger, do the following:

1. In the left pane of the screen that is displayed select the Data Source Explorer tab and expand the Database Connections group
2. Select the appropriate database.

3. In the upper right pane, click in the last icon of the pictorial path to display a list of options, then select Triggers to display the code.

4. Again, in the upper right pane select the desired trigger and in the lower pane select the Details option.