topic Stored Procedures in QlikView

Stored Procedures

Mon, 19 Mar 2012 16:57:50 GMT

Anybody knows how to use SQl stored procedures in the QV Script?

Thanks

Stored Procedures

garystrader — Mon, 19 Mar 2012 17:42:00 GMT

SQL EXEC myProcName;

Assuming the stored procedure returns a record set, you will be able to LOAD them into a table in your app.

Anything after the SQL keyword is treated as pass-through SQL and not interpreted by QlikView. It has to follow the SQL syntax of the source database system.

Stored Procedures

Mon, 19 Mar 2012 17:43:35 GMT

Hi Gary,

do you have any example or article contains any example for that?

would appreciate

thanks,

David

Stored Procedures

garystrader — Mon, 19 Mar 2012 17:47:55 GMT

I gave an example. Are you having a specific problem? Also, search the forums - there are other threads with solutions for this.

Stored Procedures

Wed, 21 Mar 2012 09:11:13 GMT

Hi Gary,

Sorry i was fast-reading your answer, and thought there might be any full scale example LoL

Btw, thanks anyway

Stored Procedures

rbecher — Wed, 21 Mar 2012 20:11:43 GMT

Hi Badr,

what is the database system? What kind of return parameter of the SP (if any..)?

- Ralf

Stored Procedures

Tue, 27 Mar 2012 20:10:11 GMT

Thanks Gary... We've used this now and it works well