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
- 11505 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 |
What is timing concept in mainframe?
I need exexution process for JCL programs
What is the meaning of keyword in JCL? What is its opposite?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
How to find the number of duplicates in a file using Sort?
lines(1,cancel)??What is meant by that??Plz explain it....
Is CPU time (TIME parameter) assigned to a JOB and JOBSTEP BOTH, by default ?
how to code instream data in procedure?
For what purpose steplib and joblib are used ?
Suppose I have five jobs to do. But I want to hold one?
Wrete a JCL to compare two files and mached records move to onc file & un mached rows wants to another file?
13 Answers CGI, DSRC, IBM,
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The disp in the JCL is SHR and the pgm opens the file in EXTEND mode. What happens ?
COBOL 
