topic How to run SQL Stored Procedure from QlikView in QlikView

How to run SQL Stored Procedure from QlikView

Fri, 05 Mar 2010 13:32:24 GMT

Hi All,

I am having un- avoidable scenario that I have to execute SQL stored procedure from QlikView.Since it is very new

for me please advice me how to take this further.IF possible please share some sample qvw with me.I have searched in qlik Community but I

could not able to find out suitable answer.Please send me or advice me what are the steps to be handled.

Thanks & Regards

Jai

hector — Fri, 05 Mar 2010 14:52:14 GMT

Hi, did you try this?


SQL //this is a reserved word of QV
EXEC SP_NAME //you can put SQL code here
; //end of QV SQL-LOAD statement

rgds

Sat, 06 Mar 2010 15:15:25 GMT

Hi,

Thanks for your kind reply.In the above case please let me knpw how to store tables which is pulled from database same like

Qv_Table:

Qv_Table into .... Qv_table.qvd;

Above is correct? wat about ODBC connection? I hope you got my question.

Sat, 06 Mar 2010 23:37:46 GMT

You can store your data into qvd with this "store" command like this ;

Qv_Table:
store Qv_Table into Qv_Table.qvd;

Best Regars,

Önder .ALTINBILEK