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
- 10880 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
How dummy is used in jcl?
Explain how can the submitting users racf authority be overridden in a job stream?
A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?
What is the function of dd disp parameter?
What is notcat 2 - gs?
Explain the hierarchy levels in jcl?
Is automatic restart possible in jcl? If yes, how?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
how you will the direct the data to spool using sysout option?
What is the function of the dd mgmtclas keyword in sms datasets?
How does jcl act on code(if you take a cobol program)?
What is the purpose of the dd keylen parameter?
What is timing concept in mainframe?
How can a stopped job be started again?
What is the purpose of dd dummy statement?
