table storing error when using if clause in load script

[madushanfernand]

Hi all

above shows the script i have written at loading. it runs without any error if i don't use STORE statement. But when i need to store that table, i used STORE key word and it gives me this error. please could some one help me correcting this?

[Somasundaram]

Hi,

It seems script is correct,

Please data model if table is available or not while running successfully.  and qvd storage path as well. 

[juliensaintmaxent3113]

hi,

your table has got data ?

just for test, can you put a space between tblconfirmed.qvd and (qvd);

tblconfirmed.qvd (qvd)

Bye

[madushanfernand · Accepted solution]

Lots of Thanks for the replies guys. i found the error my self.

it is just a colon missing after the first statement of SQL script.

that is why table not loaded.