Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to Call stored procedure in Qlikview

Hi,

I have a stored procedure which contains 3 input parameters with multiple select and Inner joins.

I want to Call the SP in Qlikview. I followed lots of Blogs but I did't got sucess to Execute the SP in Qlikview. Help me.

I am Using OLEDB and my calling method is:

  SQL CALL [DBNAME].[dbo].[ABC] @_EndTime ='2012-12-31 00:21:06.550', @_StartTime = '2012-12-31 00:21:06.550',

@_UserName = 'XYZ';

1 Solution

Accepted Solutions
Not applicable

Re: How to Call stored procedure in Qlikview

Try this GRANT EXEC ON dbo.xxxxxxx TO <UserName>

24 Replies
vikasmahajan
Honored Contributor III

Re: How to Call stored procedure in Qlikview

 

 

sql  execute  < Sql Proc Name>

vikasmahajan
Honored Contributor III

Re: How to Call stored procedure in Qlikview

 

 

sql  execute  < Sql Proc Name> < parameters>

Not applicable

Re: How to Call stored procedure in Qlikview

can you please answer me in details with full syntex.

Not applicable

Re: How to Call stored procedure in Qlikview

Not applicable

Re: How to Call stored procedure in Qlikview

Ricardo,

I already gone through the link you gave me but unfortunately it is not working for me.

any other solutions ??

Not applicable

Re: How to Call stored procedure in Qlikview

Hope this helps

OLEDB CONNECT32 TO [Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=MyDB;Data Source=.;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WID;Initial File Name="";Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False];

TableStorePoc:

SQL Exec [dbo].[GetItemsByCriteriaForUser]

                    @userId = NULL,

                    @userIdType = NULL,

                    @statuses = NULL,

                    @maxRowCount = 100,

                    @dateFrom = NULL,

                    @dateTo = NULL,

                    @onlyBasketItems = NULL

Not applicable

Re: How to Call stored procedure in Qlikview

Not Working need moreSuggestion ??

Not applicable

Re: How to Call stored procedure in Qlikview

Is your connection string proper ? are you able to connect to DB ?

Not applicable

Re: How to Call stored procedure in Qlikview

Yes connection string is correct I can pull data from any table. but I am looking to call SP in Qlikview.

FYI: in Store Procedure I have multiple select, multiple inner joins and SP is written in two parts union is ussed to join two parts of SP.

Community Browser