View previous topic :: View next topic |
Author |
Message |
eskaysem Beginner
Joined: 31 Mar 2003 Posts: 29 Topics: 13
|
Posted: Tue Jan 18, 2005 11:30 am Post subject: table to table compare |
|
|
How can we do a table to table comapre if they are lying on different databases/sub systems? I'm using OS390 on db2 ver 7.2 _________________ Thanks!,
Santosh Kulkarni |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Jan 18, 2005 11:53 am Post subject: |
|
|
eskaysem,
Do you want to compare all the columns from the both the tables or is it just the primary key columns?
If you want to compare all the columns then you need to
1. Unload the DB2 table from subsystem1
2. XMIT/NDM the unloaded file to subsystem2
3. Unload the DB2 table from subsystem2
4. Run an utiltity/pgm to compare the 2 unload files.
Hope this helps...
Cheers
kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|