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
- 11235 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 |
How dummy is used in jcl?
What is a S0C4 error ?
what is check pending option
what are the various stages of job processing?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
What is JCL LIB ?
What are the parameter we cannot use in procedure?
how to have variable length record in outrec..i have the requmt as follows.. i/p file variable lenght record output file : i need to alter the input and write into outrec(another file) sort fields: copy from(dd1) using ctl1 ctl1cntl dd * outfil fnames=xxx, outrec=(1,131) here i outrec is bombing with error..how to overcome this defect...???
What is concatenating?
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
the command to open a dataset directly from the JCL instead of opening it separately using 3.4 option.
write a jcl to execute a job by 7:00 am on jan 20,1986?
COBOL 
