topic Re: Stored Proc issue in QlikView

Stored Proc issue

Anonymous — Mon, 25 Jan 2016 09:50:01 GMT

Hi All

A bit stuck on stored proc

Trying to input parameters

SQL Execute DB.usp_rp_analysis '1222','20151201','20151231';

but getting no results

1222 is required id

20151201 is from date

20151231 is to date

Getting connection but no results, Any ideas why?

Thanks

Re: Stored Proc issue

jonathandienst — Mon, 25 Jan 2016 09:57:14 GMT

This problem is in your SQL procedure, rather than in QV. Are the parameters in the correct order, and are they of the correct type and format, especially the dates? What error messages do you get? Does this exact query work in another tool (SQLMS, Toad etc)?

Re: Stored Proc issue

Anonymous — Mon, 25 Jan 2016 09:59:43 GMT

Hi Jonathan

Yes it works in SQLManagementstudio when run

i don't get any error messages it just runs and looks like it worked apart from returning no results

all parameters are in correct order

Re: Stored Proc issue

jonathandienst — Mon, 25 Jan 2016 10:02:00 GMT

Are you running the proc in SQLMS and QV using the same username?

Re: Stored Proc issue

Anonymous — Mon, 25 Jan 2016 10:02:47 GMT

yes

Re: Stored Proc issue

asgardd2 — Mon, 25 Jan 2016 10:07:04 GMT

How do you call a procedure in QliKView?

I do it like this:

tmpdata:

SQL SELECT OID,NAME FROM GET_OID_NAME(1,1);

Re: Stored Proc issue

Anonymous — Mon, 25 Jan 2016 10:11:10 GMT

Managed to resolve the issue after visiting the following

https://community.qlik.com/thread/3223

I did an ODBC connection using Username and password...Jonathan helped in terms of thinking am i doing this wrong!

But it is now working did the folowing

SQL Execute DB.usp_rp_analysis batchid='1222',@startdate='20151201',@enddate='20151231';