MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

I have to compare the test tables and prod tables to check if there is any difference between them.

could anyone help me how to compare test and prod tables?
Is there is any tool or option in BMC tools.
Please help me in this regard.
_________________
Satya

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

satyenderd,

My suggestion:

1. Unload the test table into a flat file using DSNTIAUL utility. Unload the prod table into another flat file using DSNTIAUL utility.

2. Now that you have both the files, you can compare the flat files using sort techniques.

Check the below link to match two flat files:

http://www.mvsforums.com/helpboards/viewtopic.php?t=11&highlight=filea+icetool+match
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

satyenderd,

Check this link for information on DSNTIAUL utility:

http://www.mvsforums.com/helpboards/viewtopic.php?t=4999&highlight=dsntiaul
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks to all for your valuable suggestions.
I will check this and let you know if i face any problems.
Thanks once again.
_________________
Satya

Nic Clouston · Posted: Tue Oct 09, 2007 12:27 pm Post subject:

I would use a compare utility rather than sort - SUPERC or Comparex or whatever. They are designed for comparing whereas SORT is designed for sorting and, although it can be used for comparing, unless you require to provide an output file I would favour the dedicated utility.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.