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

    Unanswered: Comparing rows from 2 tables


    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.


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


Posting Permissions

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