Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm very new to Qlikview, and I was trying to create my first report based on a stored procedure in my MS SQL database. In other report tools, I would simply write the SQL statement as follows, but I keep getting an error in the edit script function of Qlikview. Here's my script so far:
ODBC CONNECT TO [Quantim Production] (XUserId is DIUESZFMKC, XPassword is TFSbJEFGNabcWIRKNKLB);
EXEC dbo.sp_RUNScoreEncountersINPATIENT '10/01/2011','5/18/2012','SHEARTIN';
I get connected to the DB OK, and I can do simple Select statements, but I get an "Unknown Statement" when I try to reload using an "EXEC" SQL command.
Any ideas?
-Bob
Hi,
Thank you for your inputs!!.
Could you please help in integrating oracle stored procedure data with QlikView.
I have tried all the above changes.
But I am not able to fetch Oracle stored procedure data into QlikView as well as insert records into Oracle table through stored procedure.
I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracl...
Could you please take a look at and advise for corrections.
Thanks a lot in advance.
Regards,
Laxmaiah Chowdary