Daily Qvd's Generation

[maniram23]

Hi Experts,

How to generate the Daily base Qvds. As well as monthly qvd.

Regards,

[prashanth1712]

Hi,

Use store and load daily basis.. and for monthly May be u have to load the monthly data.

[MayilVahanan]

Hi

Try like this

Daily Qvd:

Let vFreezeTableName = 'Daily_'&Date(Today(),'MMDDYYYY');

$(vFreezeTableName):

LOAD * from yourdatasource;

//Store freeze data into qvd

STORE $(vFreezeTableName) into $(vFreezeTableName).qvd(qvd);

monthly qvd:

If Floor(MonthStart(Today())) = Floor(Today()) Then

Let vFreezeTableName = 'Monthly_'&Date(Today(),'MMDDYYYY');

$(vFreezeTableName):

Load * from

Yourdatasoure;

//Store freeze data into qvd

STORE $(vFreezeTableName) into $(vFreezeTableName).qvd(qvd);

ENDIF;