Calling a stored procedure from catalog navigation¶

You can call a native stored procedure or an external stored procedure directly from the Db2 Developer Extension catalog navigation view. Only these two types of stored procedures are supported at this time.

To call a native or external stored procedure, first select the Stored procedure object type from the catalog navigation tree, then click Run from the overflow menu for the stored procedure that you want to call:

• If the stored procedure that you’re calling does not include input variables, the stored procedure runs and the results are displayed:

  

• If the stored procedure that you’re calling does include input variables, you are prompted to specify values for the variables:

  

  After you specify the values and click Run, the results are displayed.