Given a input file with duplicates how to remove the duplicate records from th

Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
Suggest New Category

Given a input file with duplicates how to remove the
duplicate records from the file using JCL?

Question Posted / kavitha

6 Answers
31893 Views
CDS, Convergys, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sudee

//STEP10 EXEC PGM=SORT,REGION=1024K
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...,DISP=SHR
//SORTOUT DD DSN=...
//SYSIN DD *
SORT FIELDS=copy
SUM FIELDS=NONE
/*
//

Is This Answer Correct ?

25 Yes

12 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / tidda

This can be done by using Sort.

1) If the first duplicate is to be kept, we use SUM
FIELDS=NONE

2) If none of the duplicates are to be kept, using SYNCTOOL
or ICETOOL, use the NODUPS option.

Is This Answer Correct ?

16 Yes

6 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / subbu

in sort field we can give SUM Fields=None

Is This Answer Correct ?

7 Yes

3 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sreedhar naidu dhekodna

We can also use the ICETOOL SELECT Operator along with its
operands for removing duplicates.

Is This Answer Correct ?

2 Yes

2 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / vivek

You can use XSUM

Is This Answer Correct ?

0 Yes

0 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / alan at accenture

the existing record of present file and the duplicate
record of previous file wnen sort both files, if both are
duplicated records both must be removed and there is no
existing record in the file. Got it? thanksalan

Is This Answer Correct ?

0 Yes

1 No

Post New Answer