Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    1

    Unanswered: Comparing rows from 2 tables

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look at the MERGE statement in the manual.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •