Invoking a stored procedure

The Scratchpad perspective displays the called procedure. The Procedure tab displays the CREATE statement for the stored procedure in view-only mode. Use the Alter editor to update native stored procedures. For more information, see Updating a stored procedure.

To invoke a stored procedure

1. In the DB2 Navigator perspective, select the required stored procedure. For more information, see Navigating to an object.
2. Select the CALL command from the Commands list. The Scratchpad perspective displays the Parameters dialog box. 

3. In the Parameters dialog box, complete the following fields and click OK:

   Field	Description
   DB2 Connection	Select the Db2 subsystem where you want to run the stored procedure.
   Commit	Select Commit or Rollback.
   Parameters Profile	Select a saved set of values to use as Input parameters.
   Input parameters	Enter data for each of the parameters listed.
   Save	To save the Input parameters as a profile, click Save, enter a name for the profile, and click OK.

   The Output tab displays a summary of the stored procedure.

4. To view results, perform one of the following actions:
   • To view all results, click View All Result Sets  .
   • To view a specific result set, on the Output tab, click the relevant View result set.
5. To save the output in a text file on your local file system, perform the following actions:
   1. On the toolbar, click View output text .
   2. In the Output Text dialog box, click Save output text .
6. To invoke the procedure again, perform the following actions:
   1. Click the Procedure tab.
   2. Click CALL  .
      The Parameters dialog box is displayed. Return to step 3.