Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld online is next week! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Executing procedures from qlikview

Hello Everyone,

             I am trying to execute sql server procedure from qlikview. The procedure takes 2 parameters as input and returns and array of 3*3 i.e 3 colums and 3 rows.

Case 1:

The script executes without error when I just submit the input parameters and dont specify the output variables to hold the output data. In this case I am not sure whether my procedure is executed or not? How to verify whether procedure is executed or not?

Case 2:

when I declare variables to hold the output data and use them when calling the procedure it gives me an error 'TOO MANY ARGUMENTS FOR THE PROCEDURE OR FUNCTION'

Is it that we cannot return multiple recordsets?

Can you please give me the syntax for the same?

0 Replies