Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

24 Replies
vikasmahajan

 

 

sql  execute  < Sql Proc Name>

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

 

 

sql  execute  < Sql Proc Name> < parameters>

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

can you please answer me in details with full syntex.

Not applicable
Author

Not applicable
Author

Ricardo,

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

any other solutions ??

Not applicable
Author

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
Author

Not Working need moreSuggestion ??

Not applicable
Author

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

Not applicable
Author

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.