Executing Stored Procedures¶
To execute a stored procedure, click Query (
) in the
dialog that displays the schema of the stored procedure.
Design Studio 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 taxid_list. Each
register has a field called taxid (client’s Tax ID).
In our example, we create two registers with the values
B78596011 and B78596012.
Execution of the Stored Procedure CalculateAvgRevenue¶
Result of the execution of the stored procedure CalculateAvgRevenue¶
Note
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.
Execution of the Stored Procedure CalculateAvgRevenue using the Design Studio.¶
Stored procedures can be also invoked from the VQL Shell using the
CALL statement (see Invoking Denodo Stored Procedures - VQL Guide).