how to create qvd from sql server

[trishita]

I have access to sql server:

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

I am trying to load the view into qvd form.How can I convert into a load statement ?

[rubenmarin1 · Accepted solution]

Hi Trishita, I think you only need:

TableName:

LOAD *;

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

STORE TableName into TableName.qvd(qvd);

DROP Table TableName; // Optional, if you want to delete the laoded table in QV.

[trishita]

Thanks a lot!!