Comparision of 2 identical tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kanaka
    New Member
    • Sep 2010
    • 4

    #1

    Comparision of 2 identical tables

    Hi,

    I have two database which reside on two different subsystem respectively.
    I would like to generate a list of matching and non matching columns list ,keys,indexes .etc
    that present in these two tables of different databases.

    Do we have any sql to generate this report from SYSIBM tables.

    i already has federated db setup in db2.

    Thank you in advance.
Working...