Interested to Buy Any Domain ? << Click Here >> for more details...
Given a input file with duplicates how to remove the
duplicate records from the file using JCL?
- 6 Answers
- 31624 Views
- CDS, Convergys, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
List in order the hierarchical levels of jcl?
I have a JCL which 20 steps. How do I execute 17 th step alone (It should execute only 17ths tep.and it should not execute 18,19,20 steps??
9 Answers IBM, Infosys, TCS, Xansa, Xchanging,
how to convert a file form fixed Length to variable length?
what are JCLLIB and STEPLIB in JCL?
Explain the purpose of dd dummy statement?
How to change default PROCLIB?
I have a COBOL program that Accepts some input data. How do you code the JCL statement for this? ( How do you code instream data in a JCL? )
How does jcl act on a cobol code?
How to view the hexa decimal value thru file aid if copy book is not present for that particular data
Explain about File Tailoring
What is the meaning of keyword in JCL? What is its opposite?
I have a sequential file in which there are 50 records. Now I want to copy all the 50 records in the reverse order into a new file? The last record in the original file should be the first record in the new file. How can I do it?
COBOL 
