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
- 32194 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 |
what are the statements that are not valid to be included in an include statement?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
Statement1 "We can not use UNCATLG in SMS managed VSAM datasets" Statement2 "We can not delete a SMS managed data set without UNCATLG it" (P-353, Saba Zameer book) Then how do we delete SMS managed VSAM datasets ?
Explain the function of dd disp parameter?
how can you check if a file is empty using jcl?
hi,i have joined in mainframe course recently. ihave a doubt ragarding restart parameter.what is d use of it. and what is d syntax for it. any one give me d answer pls.
A dd statement consists of 4 fields. Name them?
How are datasets concatenated?
how you will the direct the data to spool using sysout option?
I had 100 steps in jcl i want to execute first 10 steps only?
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
How to run cobol program using jcl?
COBOL 
