Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
1:Don't you have any parameter to pass?
2: Try changing EXEC to EXECUTE
Go through the below
https://community.qlik.com/thread/74815
let me know if it helps.
The Stored Procedure doesn't have parameters.
Hi,
On Which Database you are calling this Stored Procedure?(SQL, Oracle or Others)
Thanks,
Mukram.
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];
SQL
i tired that too its not working
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;