Interested to Buy Any Domain ? << Click Here >> for more details...
how to eliminate the duplicates in sorting
- 4 Answers
- 22281 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / seema dawlekar
WE CAN ELIMINATE DUPLICATES IN SORTING BY SORT UTILITY
SYNTAX IS
SORT FIELDS=(STARTING POSITING,LENGTH,TYPE,A),EQUALS
SUM FIELDS=NONE
THIS WILL SORT THE FIELDS IN ASCENDING ORDER AND ELIMINATES
ALL THE DUPLICATES, AS WE ARE GIVING 'EQUALS' IT WILL TAKE
THE FIRST RECORD AND ELIMINATES REST OF THE DUPLICATE
RECORDS IN A FILE.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / muttaiah
use the Sort utility, In the instream data of the sort card
Specify.
//sysin dd *
sort fields=copy
sum fields=none,xsum
/*
for this you need to have a dd stmt as
//sortxsum dd dsn=datasetname, disp=(createnew, share)
Now, the output file will have the records without
duplicates & the duplicates will be captured in the above
dsn of the sortxsum dd.
Correct me if i'm wrong
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / stu
Pandu,
Answers 1 & 3 are correct. SUM FIELDS tells SORT that only
1 record with the the same values in the SORT FIELDS will be
written to the SYSOUT. SUM FIELDS=NONE tells SORT there are
no fields to SUM, but only keep one record for each distinct
combination of the sort fields.
Examples:
SORT FIELD=1,5,CH,A) SORT FIELD=1,5,CH,A)
SUM FIELDS=(7,1,ZD) SUM FIELDS=NONE,EQUALS
----+----1 ----+----1
PANDU 1 PANDU 1
PANDU 4 PANDU 4
CRAIG 3 CRAIG 3
PANDU 3 PANDU 3
HARPO 6 HARPO 6
results in
----+----1 ----+----1
CRAIG 3 CRAIG 3
HARPO 6 HARPO 6
PANDU 8 PANDU 1
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pandu
Hi Seema Thank you for answered my question but in my view
there is no sum i.e i don't want sum if there is
esalary.suppose one table contains 'Pandu' name more than
times but i want prient only one time.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is instream data
what is DSN in JCL and what are the parameters to declare the DSN?
How can a fb file convert to vb file using sort program?
Explain about LMCOPY -
Differentiate between addressing mode and run mode.
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
How can values be passed from the job stream to an executable program?
What is the use of DUMMY statement in the JCL? What is the use of DUMMY Utility in the JCL?
As PARM can supply information to a program ? Can PARM be used to supply information to a cataloged or Inline Procedure also ?
Is it possible to define dd statements as you want?
What are s0c1, s0c4, s0c5, s0c7 and socb?
Is it possible to left uncode disp? If yes, how?
COBOL 
