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 / 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
Mention the types of job control statements?
What is the significance of addrspc parameter in exec statement?
What is catelog procedure and how many catelog procedure to use in one job?
Explain how can return codes be tested before execution of a job step?
what is JCL?
what happens in execution stage in job processing?
what is the purpose of coding class parameter in job statement?
in ways data can be passed to a COBOL program from JCL?
what is DSN in JCL and what are the parameters to declare the DSN?
Explain the function of //cntl statement?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
what is “Cond= even” and “Cond=only”?
What is the function of the steplib dd statement?
What do you understand by jcl?
What is the function of the dd mgmtclas keyword in sms datasets?