topic Re: Executing a stored procedure in QlikView

Executing a stored procedure

Mon, 09 Jul 2012 17:16:14 GMT

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

Re: Executing a stored procedure

MayilVahanan — Mon, 09 Jul 2012 17:20:55 GMT

Hi,

In qlikview , there is no option like Exec as in database.. Can you say your requirement , its help to achieve your requirement..

You can use like this.

Select * from tablename where DateField = '10/01/2011' and DateField = '5/18/2012' and NameField = 'SHEARTIN';

Hope it helps

Re: Executing a stored procedure

Mon, 09 Jul 2012 18:14:15 GMT

Yes, as I said, I've been successfuly with simple table queries, but the data I need to extract is somewhat complex, and has been consolidated into a stored procedure. Are you saying that Qlikview cannot execute Microsoft SQL stored procedures?

Re: Executing a stored procedure

MayilVahanan — Mon, 09 Jul 2012 20:57:49 GMT

Hi,

See the folllowing links:

http://community.qlik.com/message/162897#162897

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

http://community.qlik.com/message/132679#132679

Use Sql Exec dbo.sp_RUNScoreEncountersINPATIENT

Hope it helps

Re: Executing a stored procedure

jagan — Tue, 10 Jul 2012 14:07:31 GMT

Hi,

You can access data from database using store procedure like this

TableName:

SQL EXEC usp_GetData;

Hope this helps you.

Regards,

Jagan.

Re: Executing a stored procedure

Tue, 10 Jul 2012 14:39:47 GMT

PERFECT. I knew it was something easy! Thank you.

Re: Executing a stored procedure

Thu, 08 Aug 2013 19:14:55 GMT

+ ...And how can I exec procedure in package (ODBC, ORACLE)?

because same formula is not works

SQL EXEC export_pkg.set_from_date;

Re: Executing a stored procedure

Fri, 09 Aug 2013 08:45:30 GMT

it's works with CALL instead EXEC/EXECUTE

thanks

http://qlikviewmaven.blogspot.ru/2012/12/execute-oracle-procedure-from-loadscript.html

// Call Oracle data summarization procedure
sql call corp_report.update_rpt_data('$(var_COUNTRY)');

Re: Executing a stored procedure

Thu, 02 Jun 2016 13:55:03 GMT

Hi All,

Thanks for the discussion!!.

I am facing issues in integrating oracle stored procedure data with QlikView.

I am not able to fetch Oracle stored procedure data into QlikView. I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracle table

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary

Re: Executing a stored procedure

Thu, 02 Jun 2016 13:56:00 GMT

Hello Jagan,

Thanks for the discussion!!.

I am facing issues in integrating oracle stored procedure data with QlikView.

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary

Re: Executing a stored procedure

Thu, 02 Jun 2016 14:17:11 GMT

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 oracle table

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary