Capturing the non existing records

major · Post by **major** » Wed Jun 17, 2009 9:17 am

Hi all,

I need to load around 20 tables , i have separate jobs for each one of them.
Daily some of the records are rejected in one or all jobs and i have an error file to capture them with different user defined error messages ( a single file for all jobs)
Each record will have an unique no.
Now my req is i need to capture the record which is rejected for very first time.

For example if a record is rejected in 3rd,13th and 20th jobs then my error file should contains the rejected record in 3rd job.

Thanks in advance

chulett · Post by **chulett** » Wed Jun 17, 2009 9:22 am

I would probably initially capture them to separate reject / error files and then add a post-processing job that builds the combined / finalized file and enforces your 'only from the first job' rule. Of course you'd need some kind of intelligent naming convention so they sort properly in order to facilitate that.

priyadarshikunal · Post by **priyadarshikunal** » Wed Jun 17, 2009 9:50 am

or add a column in the file which keeps the job number so that you can identify the rejects from first job.

major · Post by **major** » Wed Jun 17, 2009 10:49 pm

Hi all,

Thanks for your suggestions , i will give a try and get back

ray.wurlod · Post by **ray.wurlod** » Wed Jun 17, 2009 10:57 pm

Small philosophical problem with the subject line.

major · Post by **major** » Thu Jun 18, 2009 4:28 am

Hi all,

The suggestions have been working successfully..
Thanks again.
Next time i will come up with a more apt subject line ...