In the left pane of the screen that is displayed, select the Data Source Explorer tab and expand the Database Connections group. These activity options display database objects using a development approach, so they are classified into two main groups: Configuration Repositories and Database Connections.īecause both activities have the same options, they share the same steps described below. The Develop SQL and Routines and the Tune Queries activity options Again, in the upper right pane, select the desired stored procedure and in the lower pane select the Source option to display the code. In the upper right pane, click in the last icon of the pictorial path to display the list of options, then select Stored Procedures. In the lower right pane, select the Source option to display the code. In the upper right pane, select the desired Stored Procedure. 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, Stored Procedures. To view the code of a stored procedure, perform any of the following options. The Administer Databases activity option displays database objects using a data approach, so they are classified into two main groups: databases and sets. The three activity options are described below. There are three options in IBM Data Studio called Activities from which you can view the code. #Ibm aqua data studio freeware how to#
This tutorial will show you how to view the code that is contained in a stored procedure in DB2 using IBM Data Studio.