Where does the STORE statement go in the script?

[#1]

I have an inherited long SQL statement that pulls from many files. I would like to store the results in a QVD file. Since there is no documentation on the SQLstatement, and there is no "INTO" in the Select statement, I looked at QV's table viewer, and saw the results were in a single table, "Sub_Package".

So, my question is: where do I put the following STORE statement:

STORE Sub_Package INTO SPData.qvd;

When I put it before the SQL statement, I get an error "No such table Sub_Package", and when I put it after the SQL statement's final clause (GROUP BY fields ORDER BY fields), I get a syntax error.

Do I need to put some terminator, eg. (;) at the end of the ORDER BY statement? Or is there some other syntax I'm missing here?

Thanks,

Kevin

[MayilVahanan]

Hi

     After your load statement finished.. Use store like below:

     Store Sub_Package into SPData.qvd(qvd);

     For example:

T1:

SELECT NO,
    "FirstName",
    "LastName"
FROM TableName WHERE DELFLAG = 0;

STORE T1 INTO QVD\Tablename.qvd(qvd);

     Hope it helps

[#3]

Yes, in the meantime I tried inserting a ";" after the GROUP BY in the Select, and it worked fine. Thanks for your help.