Executing Stored Procedures¶
To execute a stored procedure, click Execute () in the dialog that displays the schema of the stored procedure.
The Tool will display a dialog similar to Execution of the Stored Procedure CalculateAvgRevenue, where you have to enter the input values. Then, click Ok to execute the procedure. You can stop the execution of a procedure by clicking on Stop.
The figure below shows the
screen in which the values of the input parameters for the procedure
CalculateAvgRevenue are specified. This sample procedure receives as
input a parameter of type array of registers called
register has a field called
taxid (client’s Tax ID).
In our example, we create two registers with the values
The “Stored procedure parameters” dialog is not currently available on the Design Studio but future updates will extend the current options to progressively add them. Meanwhile, the parameters should be specified in the value section as shown in the figure below. See section Conditions with Compound Values of the VQL Guide for more details about this syntax.
Stored procedures can be also invoked from the VQL Shell using the
CALL statement (see Invoking Denodo Stored Procedures - VQL Guide).