How to combine all error messeges into one errortabl

vilasini · Post by **vilasini** » Tue Dec 18, 2007 5:21 am

Hi,

I have 5 to 6 lookups in a job and if the lookup fails indiviually it has to update the error table for each failure lookup.Is there any other way to update the error table instead of updating evey after lookup.
Help me on this.

Regards
Veda

ArndW · Post by **ArndW** » Tue Dec 18, 2007 5:32 am

No, it makes sense to do it after each lookup.

vilasini · Post by **vilasini** » Tue Dec 18, 2007 6:29 am

But,can not load the table after every lookup rt,so how to use one transformer and load to one table.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 18, 2007 3:21 pm

I normally use a shared container to receive the error code, decode it, add the job id, run time, user, etc., and insert into the error table. You can have as many references to this shared container in your job as needed.

vilasini · Post by **vilasini** » Wed Dec 26, 2007 4:23 am

Thanks for your response and we will try to use containers.