how to setup daily update of qvd

[userid128223]

Hi Everyone

This is kind of best practice question and please give example.

If you have process running on server that generates new qvd and then another one that actually takes that newly generated qvd and merges with exisitng qvd.

1) how do you setup code to do auto update everyday.

2) I know the part on how to schedule 2 qvw to run on qmc task manager.

Please share an example

thanks

[Anonymous]

This is a concept of incremental load.

Example >>

Daily_new:

Load * from <Table>

where date(update_date) >= date(today()-1)   ;                  // Any condition which is used to generate new qvd daily.

Store Daily_new into Daily_new.qvd;

drop table Daily_new;

Original:

Load * from original.qvd(qvd);

concatenate

Load * from Daily_new.qvd(qvd) ;

Store Original into Original.qvd;

In this way you can actually merge your new data to the previous one, and hence no multiple qvws will be required.

Hope this helps.

Regards

Nitin

[userid128223]

Thanks Nitin

How do you create data part automatically for each day so that you don't have to manage it.

[Anonymous]

Can you please provide you script ,

so that I can explain it to you in a much better way.