Search found 3 matches

by Srilakshmi
Fri Feb 08, 2013 6:41 pm
Forum: JCL
Topic: Merging Datasets with removing duplicates
Replies: 14
Views: 19432

Oops output order is in Alphabetic way. Sorry! then I think it will be helpful if we can add a SEQNUM at the end of each record, remove duplicates and then sort it back using the SEQNUM.
by Srilakshmi
Fri Feb 08, 2013 5:16 pm
Forum: JCL
Topic: Merging Datasets with removing duplicates
Replies: 14
Views: 19432

Hi Harsh,

Use Sortcard as below

//SYSIN DD *
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=(NONE,XSUM)

If you want the duplicate records written into some other file

Write //SORTXSUM DD DSN=FILENAME after the Outfile step

Try this :)
by Srilakshmi
Fri Feb 08, 2013 4:56 pm
Forum: JCL
Topic: Creating a dataset
Replies: 41
Views: 43097

Hi Subu, Remember that whenever you need create a new dataset you need to have Unit & Space Parameter Compulsory. Ex: //STEP01 EXEC PGM=COBOL1 //INFILE DD DSN=INFILE1,DISP=SHR //OUTFILE DD DSN=OUTFIL1, // DISP=(NEW,CTLG,DELETE), // UNIT=SYSDA, // SPACE=(CYL(10,5),RLSE))