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
- 11075 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 |
For how long a job can be executed continuously in a mainframe ?
What is RESTART? How is it invoked?
what do you mean By spooling? Expand SPOOL?
what is use of dsn parameter in dd statement?
Is condition checking possible in jcl?
What is primary allocation for a dataset?
GDG Create syntax ?
Explain the purpose of dd * statement in jcl?
Name what parameter directs the output of the job log dataset?
Is their any set of rules for dd? Explain.
if we have a job consist of two steps and each step calling a proc having 10 steps each then how many steps are counted only 2 or 22(10+10+1+1)? can we have more than 255 steps in a single job?
How can the submitting users racf authority be overridden in a job stream?
COBOL 
