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.

by using cond parameter maximum 8 cond can be coded in single cond means ?explain

0 Answers  

---

what is the difference between return code and maxcc?

2 Answers   iGate,

---

i want to store 20 digits . how will u do it in cobol ?

0 Answers  

---

in catalog procedure i have step1 dd dsn=filea dd dsn=fileb dd dsn=filec ur concatenaning all the files. but i need to override fileb with file 2 ? can anyone give the ans pls for ths

1 Answers   DELL,

---

What is the purpose and meaning of the REGION keyword and what JCL statement is it associated with?

3 Answers   IBM,

---

What it does If we specify TYPRUN=P & it is not substituted by SCAN 0r HOLD in VALUE SET.

0 Answers  

---

How to delete AIX ? i) IEBGENER ii) IDCAMS iii) PURGE iv) All of the above

3 Answers   HSBC,

---

How system will identify whether user wants to create PS or PDS? If answer is SPACE parameter then why we need to pass ps or po as dataset organisation while creation

1 Answers  

---

What is notcat 2 - gs?

0 Answers  

---

What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?

3 Answers  

---

How to override loadlib?

0 Answers   Fiserv,

---

a job have 5 steps and it will executes a proc which have 5steps in it. now i have to execute step3 only when step2 of proc executes successfully

3 Answers  

---