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
How to combine all error messeges into one errortabl
Moderators: chulett, rschirm, roy
No, it makes sense to do it after each lookup.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
But,can not load the table after every lookup rt,so how
But,can not load the table after every lookup rt,so how to use one transformer and load to one table.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.