MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

table to table compare

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
eskaysem
Beginner


Joined: 31 Mar 2003
Posts: 29
Topics: 13
PostPosted: Tue Jan 18, 2005 11:30 am    Post subject: table to table compare Reply with quote
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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Tue Jan 18, 2005 11:53 am    Post subject: Reply with quote
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
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group