View previous topic :: View next topic
|
Author |
Message |
ashokakash
New User
Joined: 15 Nov 2006 Posts: 21 Location: Chennai
|
|
|
|
Hello,
I know we can unload and load tables using utilities. Is there any utility to compare tables (i) of same region (ii) of 2 diff region? |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Compare all the columns or just some? You can write a join query to do it, returning only those rows from the tables that don't match |
|
Back to top |
|
|
ashokakash
New User
Joined: 15 Nov 2006 Posts: 21 Location: Chennai
|
|
|
|
Hi Steve,
Thanks for your quick response. It is actually 2 different tables. Need to compare IT table and FV table (All the rows) Similarly, Fv table to PROD tables.
New changes done in IT needs to be loaded into FV. Before that we need to compare whether both the tables or same or different for documentation purposes. |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
As EComp can compare almost any objects on mainframe, it can also easily compare two DB2 tables ( or one DB2 table against an ubload ). |
|
Back to top |
|
|
ashokakash
New User
Joined: 15 Nov 2006 Posts: 21 Location: Chennai
|
|
Back to top |
|
|
|