| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
VVRAVINDRA
Joined: 04 Aug 2008
Posts: 8
Location: Chennai
|
| Posted: Mon Aug 18, 2008 1:18 pm Post subject: To compare rows wise datas for same table in Prod and Test |
|
|
Hi Folks,
I need to compare row wise data for the same table in both production and test and need to list the non-matching rows, I tried to unload the two tables to flat files and do a 3.13 compare but I'm not getting the desired results. Does anyone have better solutions.... |
|
| Back to top |
|
dbzTHEdinosauer
Joined: 20 Oct 2006
Posts: 1639
Location: germany
|
| Posted: Mon Aug 18, 2008 3:04 pm Post subject: |
|
|
db2 vsn 9 has an object compare utility.
google has about 887,000 hits on 'comparing db2'
write your own. sysrecs to compare, syspunch would provide column name based on offset. |
|
| Back to top |
|
VVRAVINDRA
Joined: 04 Aug 2008
Posts: 8
Location: Chennai
|
| Posted: Mon Aug 18, 2008 3:22 pm Post subject: Reply to: To compare rows wise datas for same table in Prod |
|
|
| Hi Thanks for the reply..Googling didn't get me thru my destiny...If you have some kind of JCL that could help me...it would be grateful |
|
| Back to top |
|
dbzTHEdinosauer
Joined: 20 Oct 2006
Posts: 1639
Location: germany
|
| Posted: Mon Aug 18, 2008 3:25 pm Post subject: |
|
|
| jcl for what? |
|
| Back to top |
|
dick scherrer
Joined: 23 Nov 2006
Posts: 8733
Location: 221 B Baker St
|
| Posted: Mon Aug 18, 2008 8:08 pm Post subject: |
|
|
Hello,
Quote: but I'm not getting the desired results. What results are you getting? What results do you want?
If you post a bit of sample data from the 2 unloads and the undesired result from the compare, we may be able to offer suggestions.
Is it possible that the table definitions are now different between prod and test? If so, you will need to work with individual columns rather than entire rows (or write your own compare). |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
