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
- 32209 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 |
how can i code cond parameter in procedures ? i have a jclk calling a proc which has 10 steps i want to execute from step 5 to step 10 where can i code restrat parameter or cond parameter for ths
How do you submit JCL via a Cobol program?
Explain how can a stopped job be started again?
There are 2 steps in a JCL. If the first step abends due to system or user abend and the second step has COND specified as EVEN or ONLY, will this step still be executed inspite of the abend in the previous step?
How do you find which GDG is using which dataset?
In sms datasets, what is the function of the dd avgrec keyword?
If job is submitted with typerun = hold then how can we submit the same job?
ihave ten flatfile in that iwant to concatinate all the files except file 5,6 into output file by uing jcl? how to do this? give me detail yntax for tis?
Hi, can any one tell about " How do u eliminate the duplicates "
Can there be 2 job statements in a JCL? If yes what is the purpose of doing tha?
What is S322 abend ?
We have 100 steps in a procedure and we need to run the jcl and execute only 25th step in the proc and not the remaining steps. How can we do it?
5 Answers IBM, JPMorgan Chase,
COBOL 
