From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Execution dialog lets you execute extended procedures, functions, and procedures.

Platform and object type availability

DB2 LUW DB2 z/OS MySQL Oracle SQL Server Sybase ASE

Extended procedures



To Compile an Extended Procedure, Function, or Procedure

1. In the DBArtisan Datasource Navigator/Explorer, select a valid object node. Objects of that type are shown in the right pane.
2. Right click the target object and select Execute from the context menu.
Note: If the extended procedure, function, or procedure takes input parameters, you are prompted to provide values.

The Results editor opens, showing either results of a successfully executed extended procedure, function, or procedure, or showing error messages if execution was not successful. For details, see Using the Results Editor.

Working With Execution Parameters

If you initiate an Execute action against an extended procedure, function, or procedure that takes input parameters, a dialog prompts you to provide parameter values and otherwise manage parameters.

The Procedure Execution dialog lets you:

  • Save input parameters as *.prm files to preserve specific input parameter configurations.
  • Open *.prm files to save the effort of reentering specific input parameters.
  • Reset parameters to their default setting.

The table below describes the options and functionality of the Procedure Execution dialog:

Option Description


Specify the required input parameters in this window. If input parameters are not required for the execution of the target procedure, a message displays in this window, stating that the procedure “has no input parameters. Press execute to run it.”


Click to open an Open dialog, from which you can open an existing *.prm file. The saved parameters immediately populate the dialog box upon opening.


Click to save the values of your input parameters as a *.prm file. You can reopen a saved *.prm file from this dialog box at any time.


Click to reset the parameters in the Parameter window to their default values.


Select to gather default information from the data dictionary. ORACLE ONLY: You can not specify non-default parameters after specifying a default parameter.


Click to execute the procedure once you have entered values for all required parameters in the Parameter window.