i want write OUTPUT file and error file from 2 tables....

anatha · New User Joined: 19 Jan 2006 Posts: 7

I have two files Employee(Master file) & Department(Child file). In both the files one
common column is there. I want to write OUTPUT file whose details contain in both
the files. If any one didn?t contain in Department file those records write into
ERROR file.
:(

anatha · New User Joined: 19 Jan 2006 Posts: 7

I have 3 Procedures. Each procedure contain 4 steps. I used 3 procedures in one Job.
My job is abended in 2nd step of 3rd procedure. How do u restart the job?

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi anatha,
It seems that both your qustions are distince. ( are they?).

1. The title of the topic says, there are two tables. and the description of the question says that it has two input files. Master and child(well, what is a child file?).
in both the ways, you need to write a cobol/db2 or vanilla cobol program.

2. you can use restart = (proc.step) in your job card and resubmit the job.

sbalajibe · New User Joined: 15 Aug 2005 Posts: 62

Hi anatha,

please explain the first question clearly so that we can answer clearly

thanks
balaji

anatha · New User Joined: 19 Jan 2006 Posts: 7

Hi parikshit123 ,

Sorry please ignore subject line .I have 2 files not tables.

Thanks ,
Anatha

sbalajibe · New User Joined: 15 Aug 2005 Posts: 62

hi anatha,

my suggestion would be sort both the files on the common column then
write a comparison logic to write the output and error files

if u need more please give us the record layouts and file structures

thanks
Balaji