topic Issue storing data pulled from stored procedure. in QlikView

Issue storing data pulled from stored procedure.

Fri, 27 Jan 2012 20:41:09 GMT

Hi,

I have an issue storing data called from a stored procedure into a .Qvd. If I just load from the stored procedure with the SQL EXEC Stored_procedure; I get the data correctly loaded. Its only when I add the Store... into... (qvd); statement afterwards that my data fails to load.

Any input?

Issue storing data pulled from stored procedure.

Fri, 27 Jan 2012 21:56:02 GMT

Double check your store statement as that was my problem.

Issue storing data pulled from stored procedure.

Sokkorn — Sat, 28 Jan 2012 05:04:49 GMT

Hi,

Check this

[Data]:

SQL EXEC Stored_procedure;

STORE [Data] INTO Data.qvd;

DROP TABLE [Data];

Regards,

Sokkorn Cheav

Issue storing data pulled from stored procedure.

Sun, 29 Jan 2012 17:09:54 GMT

it can be that the store path you have given is not reachable by Qlikview. So, just check your path.

To check if it is storing properly, you can verify with just

store data into data.qvd(qvd);

It will store your qvd into the current directory.

Also, if there is already a qvd file with same location in where you are trying to store your qvd, just delete that file because sometimes that file may be locked for writing and so is not able to be replaced with new generated qvd.

let me know, if problem still persists.

...

Ashutosh

Issue storing data pulled from stored procedure.

makkemik — Tue, 20 Mar 2012 13:18:45 GMT

you can write like this;

data:

load [data fields];

sql execute [Store_Procedure];

Dont forget to add in your connection string "mode is write"

also in your connection settings check boxes should be checked (read/write mode and ececute 3rd party programs). It should be worked, I tested with no problem.

good luck,

Murat

Re: Issue storing data pulled from stored procedure.

binujose1982 — Thu, 14 Jun 2018 05:11:41 GMT

Thank you. Its worked.

Regards,

binu