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
- 10978 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 their any limit for data sets?
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 jcl work to handle various input output file operations?
Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:
How to pass data to a program that is coded in an exec statement?
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
how to run batch program without jcl?
what is use of dcb parameter in dd statement?
What is the function of dd name parameter with a 2 part structure; audit.report?
Explain the purpose of dd * statement in jcl?
What is the use of symbol // in jcl?
How is a type of file defined in the jcl that executes the cobol program?
Explain the function of dd name parameter with a 2 part structure; audit.report?
how to do automated restart when a job abends?
I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?
