deva_048 wrote:Have to compare two datasets was having huge records
Dataset 1:Orignial records+Duplicate records
Dataset 2:Original records
I want to compare both datasets and result should be stored into new dataset ie)Duplicate records .I tried superc utility and sort xsum not getting a perfect match.
Note: To compare whole dataset not any specified column
Do you mean that the LRECL is big? Or there are a "huge" number of records?
What do mean by "duplicate" records? Have records been duplicated in their entirety? If this is not "normal", then the "duplicates" could be identified from the one file alone.
However, if you are saying you want a file of all the records which are on Dataset 1 which are not on Dataset 2, then JOINKEYS should be a good starting point.
You need to tell us the LRECL and RECFM if you want further assistance with the actual code.
Note that if you go ahead with this yourself, if would be a very good idea to list out records from Dataset 2 which don't match Dataset 1, as this would indicate a hole in your theory, so it would be nice to confirm that this does not happen.