Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error While creating the QVD table

Hi,

I am new to QlikView.

I am trying to create the QVD table explicity using the Store statement from the File-Edit script section. I am getting the Error as Table not found. If i am trying with Buffer it is working fine.

Please find the scripts i tried to create the QVD table

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX);





STORE

* FROM XXXX WHERE Status<4 into test.qvd;



Also i tried to create by the below way as well

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX);



STORE

* FROM XXXXX WHERE Status<4 into {C:\Documents and Settings\All Users\Application Data\QlikTech\QlikView\test.qvd];

Please help me on this issues. Is it like i need to create the table and then use the table in the Store statement. If so please let me

know the step by step .

0 Replies