Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to run SQL Stored Procedure from QlikView

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

3 Replies
hector
Specialist
Specialist

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

Not applicable
Author

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.

Not applicable
Author

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