Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2012
    Posts
    4

    Unanswered: [DB2]Comparing two table's in different database

    How to compare two tables which are in different databases in same server and also how to compare two tables which are in different databases in different servers?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    One word: federation.


    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Easiest way is to export the table in one datebase and load it into a table on the other database.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    In my former life I would have written a balance-line cobol program to compare the both. Those were the days....

    Perhaps you can do the same using perl or python?? I suppose that `Jackson like` program structures can be used in any language.
    (Jackson structured programming - Wikipedia, the free encyclopedia)
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  5. #5
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    In my former life I would have written a balance-line cobol program to compare the both. Those were the days....
    Still quite common today on the mainframe - as well as on UNIX

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by papadi View Post
    Still quite common today on the mainframe - as well as on UNIX
    Yes I know. But COBOL development activities moved to another continent
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  7. #7
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Yes, but everywhere i've been that does mainframe work still has the compiler/linkedit.

    And most of this "matching" could be done with better performance using the sort product on the system

    Just depends on the amount of analysis of the data is needed.

Posting Permissions

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