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
- 9897 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreejith
read file-1
1-a
2-b
3-c
4-d
5-e
6-f
also move record in to table1 that is decalred in ws with
legth 14 until read all the record from file-1
then
read file-2
move each record into table1 and variables g,h....up to for
8 records
now the table contain 16 item
then use legth variable l
then compare each variable from table for each matching
incriment the variabe length. after searching all item from
table
compare the legth with 1
if it is greater than one eliminate
other wise write it to the output file-3
ok
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you understand error(execution phase)?
What is jcl in mainframe?
Explain how can a jobs execution priority be modified?
what are the statements that are not valid to be included in an include statement?
Can an individual step be restricted from using all the jobs allowed cpu time?
define cond parameter in jcl?
whats the diff bw the evaluate also and and?
what happens in conversion stage in job processing?
Explain dd statement in jcl?
List in order the hierarchical levels of jcl?
What is the function of the dd dcb keyword?
if the submitter of a job wants to inform another user about the job completion, how can it be done?
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?
What do you understand by jcl?
What is multithreading in jcl?
