I have a parallel job which has a transformer stage with 2 output links.Separate constraints will be there for each link.Both the output links will be connected to DB2/UDB enterprise stages which have Update queries to Update the same tables.
So, as we know that we cant Update the same table at a time with two update queries I just want to know how to trigger the second link after the first link.Whether i can keep any constraints on the job such that the first link is executed before the second.
Thanks,
vputta
How to trigger one link after the other
Moderators: chulett, rschirm, roy
I'd disagree with not being able to update the same table at the same time to start with - it totally depends on the impact of those queries and the level of locking they cause. Having said that, I don't believe you can achieve what you require, link ordering will make one link operate before another, but at a row level. You need dependencies in place between different jobs if you still want to achieve what you were setting out to.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
Based on the way the question is asked - "trigger the second link after the first link" - that's how it works and is controlled by Link Ordering. If you mean what miwinter surmised, it cannot be done directly but can be achieved by introducing a "process break" in the second link before the target stage. This will allow the first link to complete before the second link starts delivering any rows.
Luckily, there was a post recently on this very topic which a search for... "process break"... should turn up because I used the same phrase there, from what I recall.
Luckily, there was a post recently on this very topic which a search for... "process break"... should turn up because I used the same phrase there, from what I recall.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: How to trigger one link after the other
Arndw..could u be more specific ?
This is thread which Craig suggested you look at.