IBM Mainframe Forum

Hi,

I use below JCL to find unique and duplicate records.......



I request you to help me the SORT card using Joinkeys feature to achieve the same.

Please help.

Thanks.

Your SUM statement does not identify solely the unique records and print them to SORTOUT. It prints the unique records AND the first of equally keyed records to SORTOUT. SORT with a SUM statement can be used with a single or multiple input data sets.

The JOIN feature is used to compare records from two input files, not within a single input file.

What exactly are you trying to do?

The application has to be designed based on the requirement. You seem to have decided to use JOINKEYS, whatsoever the requirement may be!

I used REFORMAT FIELDS with joinkeys statement to achieve same purpose.....



Thanks.

ranga_subham wrote:I used REFORMAT FIELDS with joinkeys statement to achieve same purpose.....

Select all

//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(1,4,A)
JOINKEYS FILE=F2,FIELDS=(1,4,A)
REFORMAT FIELDS=(F1:1,4)
SORT FIELDS=COPY

Thanks.

The above job is nowhere related/equivalent to the one which you showed first. Which purpose you have achieved in common?!!!