I would like to sort the below file based on column 1 to 3 & column 21 to 25 by eliminating the duplicates record so that in my out put file must have only column 1to 3 & column 21 to 25.
I have used the below JCL but still I’m getting the duplicate records. Could some body help on this?
i/p file:
350100202 ¿F à ä 49050 åc*50 N ° î< o N
350100202 ¿F à ä 49050 åc*50 N ° î< o N
850100202 ¿F à ä 49050 åc*50 N ° î< o N
850100202 ¿F à ä 49050 åc*50 N ° î< o N
850100206 ¿F Ì k<45770 à 50 N ß N
850100206 ¿F Ì k<45770 à 50 N ß N
850100206 ¿F Ì k<45770 à 50 N ß N
o/p required:
35049050
85049050
85045770
Jcl used:
//SORT0Q EXEC PGM=SORT,COND=(0,LT)
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=xxx,DISP=SHR
//SORTOUT DD DSN=yyy,DISP=OLD
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,3,4:21,5)
SUM FIELDS=NONE
/*
//*
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=xxx,DISP=SHR
//SORTOUT DD DSN=yyy,DISP=OLD
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,3,4:21,5)
SUM FIELDS=NONE
/*
//*
).
