update pb

[master_student]

Hello community,

I have an update pb.

here is  the script : to get data for a year in my qvd

test:

load *;

select * from xx

where date > '2016-01-01'

store test into case.qvd

AND then every day at 5 am whene the database is accessible I execute a reload task via QMC to run this script

test:

load *;

select * from xx

where date > today ()-1 // get day-1 data

concatenate

load * resident case.qvd;// get the data from my qvd

store test into case.qvd

my probleme is my data contains a status field that change. whene I do as I mentionned above (using qvd) I didn't get status updated . I can't run the script for a year evey time because the database is not accessible all the day.

What do you suggest please as a solution.

Thanks

[swuehl]

Do your DB records hold a LastModified date field or something similar?

Something you can query to see which records changed?

[master_student]

yes.

[swuehl]

Then I suggest that you use this field in your WHERE clause for the incremental update.

Have a look at case 3 here:

Using QVD files for incremental load ‒ QlikView