Interested to Buy Any Domain ? << Click Here >> for more details...
If we want to see the eliminated duplicate record thru
SORT, how its output file will be managed
- 6 Answers
- 11325 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / chandrakant sinha
To remove duplicates we need to give :
SUM FIELDS = NONE
in SYSIN DD *
| Is This Answer Correct ? | 14 Yes | 0 No |
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 |
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 |
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 |
Answer / devendra acharya
it can be happen by using
SORT FIELDS=COPY
| Is This Answer Correct ? | 2 Yes | 11 No |
Is automatic restart possible in jcl? If yes, how?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
Is it possible to left uncode disp?
how to see the latest generation in gdg?
how to purge 50 initiators continuously?? console commands??
how you can access an uncataloged dataset in a JCL?
Explain in DD statement what is the use of DCB parameter?
Why 16 is used in calculating the DPRTY ? as, DPRTY = (num1, num2), THEN, DPRTY = 16* num1 + num2
What does a disposition of (NEW,CATLG,KEEP) mean?
Name the statement which can be used to send data to another mvs jes3 node?
i have 3 steps in my jcl, where i want to run only one step at a time depending on the variable. How should i give the condition statement... I have tried this with two steps which is working but not able to add condn for the 3rd step. can anyone help me... I want to know the cond stmt which i can code in step 3 and step4, so that only either step2 or step3 or step4 executes
Explain the hierarchy levels in jcl?
COBOL 
