News and modified rows STORING

[#1]

Hi,

I have a table like this (using QVD STORE if neccessary):

LOCATA	FOLLETO	PRIMER_SERVICIO	PAXES	ORIGEN
130000011	FV1PU	22/08/2011	2	MAD
130000229	5A030	12/09/2011	2	OVD
130000230	FV1PU	03/09/2011	2	MAD
130000776	FI0RM	05/11/2010	2	MAD

Every day I receive a new table with new and modified rows like, for example this:

LOCATA	FOLLETO	PRIMER_SERVICIO	PAXES	ORIGEN
130000229	5A030	22/09/2011	2	OVD
130000235	FV1PU	03/09/2011	2	MAD

I would like to know how to update the first table with the data in the second table, by LOCATA.

So it should result like this:

LOCATA	FOLLETO	PRIMER_SERVICIO	PAXES	ORIGEN
130000011	FV1PU	22/08/2011	2	MAD
130000229	5A030	22/09/2011	2	OVD
130000230	FV1PU	03/09/2011	2	MAD
130000776	FI0RM	05/11/2010	2	MAD
130000235	FV1PU	03/09/2011	2	MAD

Remaining the LOCATA 130000011, 130000230, 130000776 as they were, changing locata 13000229 in its PRIMER_SERVICIO date and adding LOCATA 130000235 as a new row.

Thanks

[swuehl · Accepted solution]

Please have a look into the QV cookbook, in particular into the  Incremental Load sample:

http://robwunderlich.com/downloads/

It explains quite well how to do an incremental load while taking care of updated, deleted, new records.