Execute

From RapidSQL
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 ITB/FBD MySQL Oracle SQL Server Sybase ASE

Extended procedures

Functions

Procedures

To Compile an Extended Procedure, Function, or Procedure


1. In Rapid SQL, expand the node corresponding to valid object type. Objects of that type are displayed below the object type node.
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 tab 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 Tab.

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

Parameter

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.”

Open

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.

Save

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.

Reset

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

Default

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

Continue

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