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.

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

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

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.

What is job control language?

0 Answers  

---

How to execute only th 15th step of JCL consisting of 50 steps?

12 Answers   Bank Of America,

---

what is the alternative to model parameter?

0 Answers  

---

How do you submit JCL via a Cobol program?

2 Answers   Cap Gemini,

---

A maximum of 100 chars can be passed to Cobol through Parm in JCL, If we want to pass more than 100 Chars how we can do it ?

3 Answers   IBM,

---

JCL Example: // //RUNJCL JOB CLASS=5,MSGCLASS=6,NOTIFY=&SYSUID //STEP01 EXEC PGM=IEFBR14 // .. .. If this JCL will run or it'll throw the ERROR?

4 Answers   HCL,

---

What is the error code SOC01 indicate ?

5 Answers   Microsoft,

---

What do you do if you do not want to keep all the space allocated to a dataset?

2 Answers  

---

Which is the most widely used batch performance monitor for DB2?

2 Answers  

---

I have 5 generations in my GDG. How do I code in the JCL to consider all the 5 versions of the GDG ?

5 Answers   Xansa,

---

Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?

1 Answers   L&T,

---

WHAT WILL HAPPEN TO A FILE IF DISP=(MOD,DELETE,DELETE)

8 Answers   ADP,

---