Hi,

I'm looking for a suitable DB2 query that will

a) Compare the column values of 2 similar length records from different tables (e.g. i have a new data feed (x) and need to check if there are any data updates when compared to the existing record (y)

b) After comparing, if there are any difference between the column values of 'x' and 'y', I should be able to update only the column values that have changed rather than the whole record 'y'

Any help here will be deeply appreciated. Thanks.

JV

Look at the MERGE statement in the manual.

Andy