This tutorial will show you how to view the code that is contained in a function in DB2 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 function, 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 Application Objects, User-Defined Functions.
2. In the upper right pane, select the desired Function.
3. In the lower right pane, select the Source 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 User-Defined Functions.

2. Again, in the upper right pane, select the desired function and in the lower pane select the Source 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 function, perform any of the following options.

Option 1

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 to expand its objects tree.
3. Select Schemas, User-Defined Functions and right click on the desired function.
4. Choose the Properties option from the context menu.

5. Finally, in the lower right pane select the Source option.