I have a query.. There are 2 datasets A and B.
How do I retrieve the records which are in A but not in B?? Please help.
I used SUPERCE utility. It gives just the no.s of the unpaired records. How do I get the actual unpaired records??
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
If you are using 3.13 to do a compare and you cannot see the difference you must set a different request in Listing Type:
These are the value of this menu:
_ 1. OVSUM
These explanation are from the help of SUPERCE:
OVSUM Lists only the overall summary of the data set or PDS comparison.
If partitioned data sets are compared, the listing includes a summary
line for each member selected from the PDS.
Delta Lists the differences between the source data sets, followed by the
overall summary results. Differences are flagged to the left of each
CHNG Lists the differences between the source data sets, plus up to 10
matching output lines before and after the differences. This listing
is like the delta listing, but includes surrounding matched lines as an
aid in recognizing changed areas of the source data sets.
Long Lists the complete new data set with the old data set deleted data
interspersed in the output listing. Both inserted and deleted output
data is flagged. The format is the same as the DELTA with all matching
Nolist No listing output is produced. A ISPF message displayed after
the SuperC program execution is the sole method to determine the results
of the compare operation. You may wish to use the NOLIST option when
you use one of the UPDATE comparison options to generate an update data
set and the listing is unimportant.
NOTE: The listing type default for Line, Word, and Byte compare is DELTA.
The listing type is ignored for File compare as other File compare
process options are used to determine the listing requirements.
I think that you have set the OVSUM option, try to change it!
This method has some limit and if you want to compare with other tool your file I suggest you as Rupesh say to search in this forum or in DfSort because there are really interesting alternative to 3.13