Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Yes, in the meantime I tried inserting a ";" after the GROUP BY in the Select, and it worked fine. Thanks for your help.