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!!
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
when does a dataset go uncataloged?
For what purpose steplib and joblib are used ?
List in order the hierarchical levels of jcl?
I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?
What is job control language?
Can we call instream to catalog and catalog to instream?
How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?
what is “Cond= even” and “Cond=only”?
Are there any set of rules for the names of the steps used in a job?
how do you access an uncataloged dataset in a jcl?
What are steplib and joblib? What for they are used?
What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?
How do you create a temporary dataset?
How do you overcome this limitation ?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.