If we want to see the eliminated duplicate record thru SORT, how its output fi

Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
Suggest New Category

If we want to see the eliminated duplicate record thru
SORT, how its output file will be managed

Question Posted / dhan

6 Answers
11268 Views
Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / mahaveer

//SORTXSUM DD DSN=datasetname,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(1,4),RLSE),
// DCB=(RECFM=FBM,LERCL=80,BLKSIZE=800)
.
.
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=NONE,XSUM
/*

We can see the eliminated duplicate records in sortxsum

Is This Answer Correct ?

16 Yes

1 No

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / chandrakant sinha

To remove duplicates we need to give :

SUM FIELDS = NONE

in SYSIN DD *

Is This Answer Correct ?

14 Yes

0 No

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / atreyee

//STEP1 EXEC PGM=SYNCSORT
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTIN DD DSN=SORT.IN,DISP=SHR
//SORTOUT DD DSN=SORT.OUT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,SPACE=(CYL,(1,10),RLSE),
//
// DCB=(*.SORTIN)
//SORTXSUM DD DSN=SORT.OUT.DUPLICATE,
// DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,
// SPACE=(CYL,(1,10),RLSE),
// DCB=(*.SORTIN)
//SYSIN DD *
//SYSOUT DD SYSOUT=*
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE,XSUM
//SYSPRINT DD SYSOUT=*

Is This Answer Correct ?

5 Yes

0 No

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / subramanyam reddy

//sysin dd *
sortfields=(1,3,ch,a)
sumfields=none,xsum
/*
//
where 1 is starting postion
3 is length
'ch' means charactor
'a' assending

Is This Answer Correct ?

2 Yes

0 No

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / devendra acharya

for eliminating duplicate record thru sort
we use
SORT FIELDS = SUM
in SYSIN DD*.

Is This Answer Correct ?

3 Yes

5 No

If we want to see the eliminated duplicate record thru SORT, how its output file will be managed..

Answer / devendra acharya

it can be happen by using
SORT FIELDS=COPY

Is This Answer Correct ?

2 Yes

11 No

Post New Answer