topic Re: Loading Stored Procedure data in Qlikview? in QlikView

Loading Stored Procedure data in Qlikview?

priyav24 — Wed, 25 Nov 2020 16:16:04 GMT

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

pradosh_thakur — Sun, 31 Dec 2017 07:54:12 GMT

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

2: Try changing EXEC to EXECUTE

Go through the below

let me know if it helps.

priyav24 — Sun, 31 Dec 2017 07:56:28 GMT

The Stored Procedure doesn't have parameters.

mdmukramali — Sun, 31 Dec 2017 08:00:21 GMT

Hi,

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

Thanks,

Mukram.

pradosh_thakur — Sun, 31 Dec 2017 08:01:44 GMT

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];

priyav24 — Sun, 31 Dec 2017 08:03:14 GMT

SQL

priyav24 — Sun, 31 Dec 2017 08:06:16 GMT

i tired that too its not working

priyav24 — Sun, 31 Dec 2017 08:18:14 GMT

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;