Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyav24
Creator II
Creator II

Loading Stored Procedure data in Qlikview?

Hello Everybody,

          How to Load SQL Stored Procedure Data into Qlikview.

I have Used below command

SQL EXEC  [DBNAME].[SCHEMANAME].[PROCEDURENAME]

I am not getting any error but data is not loading.

Thanks in Advance,

Priya

1 Solution

Accepted Solutions
priyav24
Creator II
Creator II
Author

Its Working fine now ,The issue i have used the temptable in the Stored Procedure due to which the data was not loading.

Syntax:

SQL EXECUTE  [DBNAME].[SCHEMANAME].[PROC NAME];

SELECT * FROM TEMPTABLE;

View solution in original post

7 Replies
pradosh_thakur
Master II
Master II

1:Don't  you have any parameter to pass?

2: Try changing EXEC to EXECUTE

Go through the below

http://www.c-sharpcorner.com/UploadFile/35fef0/connection-of-stored-procedure-in-qlikview-applicatio...

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

let me know if it helps.

Learning never stops.
priyav24
Creator II
Creator II
Author

The Stored Procedure doesn't have parameters.

mdmukramali
Specialist III
Specialist III

Hi,

On Which Database you are calling this Stored Procedure?(SQL, Oracle or Others)

Thanks,

Mukram.

pradosh_thakur
Master II
Master II

go through the links i provided and did you try changing exec to execute? may be just may be this will help

load *;

SQL EXECUTE  [DBNAME].[SCHEMANAME].[PROCEDURENAME];

Learning never stops.
priyav24
Creator II
Creator II
Author

SQL

priyav24
Creator II
Creator II
Author

i tired that too its not working

priyav24
Creator II
Creator II
Author

Its Working fine now ,The issue i have used the temptable in the Stored Procedure due to which the data was not loading.

Syntax:

SQL EXECUTE  [DBNAME].[SCHEMANAME].[PROC NAME];

SELECT * FROM TEMPTABLE;