Results 1 to 2 of 2

Thread: comparision

  1. #1
    Join Date
    Sep 2007

    Unanswered: comparision

    Hi all,

    In one instance i had two diffrent databases , i want the distinct tables from two databases .

    Example: I had one instance named db2 in that i had two databases sample1 and sample2 , so there are 10 tables in sample1 and 15 tables in sample2 . Now i want distinct tables from both the batabases. So i want to write a script for that. Please reply as soon as possible.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Use DB2 federation and access the catalog views in one database from the other database via nicknames. Then you can use regular SQL to find the differences.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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