Error While creating the QVD table

[#1]

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 XXXXX 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 .

[johnw]

You can only store a table that has already been built. So your script would look something like this:

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

[My Table]:
LOAD *
;
SQL SELECT *
FROM ARADMIN."HPD_HELPDESK"
WHERE Status<4
;

STORE [My Table] INTO test.qvd (QVD);