Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have a requirement
File A : I have 6 records out of which 4 are same.
File B: I have 8 records out of 6 records are same.
The 4 records in FILEA and 6 records in FILE B are same. If
we substract we will get two records, I need these two
records in output file
This is because to remove the duplicates from the database.
Through easytrieve we can compare but for that there should
not duplicates, but in my file I have duplicates.
Thanks in advance!!
- 2 Answers
- 10839 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay
It is simple, you no need to code ezt pgm for eliminating
the duplicate records. Try these 2 steps to eliminate the
duplicates.
Step-1: Use sort on file 1 and use sumfields=none on the
key field, then you can get only 2 records in the output
file.
Step-1: Follow the above procedure for the file 2.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Is it possible to code instream data in a PROC?
How dummy is used in jcl?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
how you can access an uncataloged dataset in a JCL?
I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.
How to submit a jcl from cics?
How do you access an uncatalogued dataset in a jcl?
What do you know about jcl?
What does a disposition of (MOD,DELETE,DELETE) mean ?
How to override loadlib?
Name what parameter directs the output of the job log dataset?
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
List the different components of jcl statement?
Is it possible to left uncode disp? If yes, how?
Explain the function of a dd statement?
