How to abort job based on constraint
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
How to abort job based on constraint
I know its not a good practise to abort job.
But based on requirment i need to abort job based on a condition in Transformer.Is there any way to do it.I searched in form i didnt get the needed information So any one can help on this ?
But based on requirment i need to abort job based on a condition in Transformer.Is there any way to do it.I searched in form i didnt get the needed information So any one can help on this ?
Amith Chalasani
Infosphere Solution Architect & Admin
Northern Trust
Infosphere Solution Architect & Admin
Northern Trust
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's impossible not to pass a parameter. If you don't give it an explicit value it will take its default value. If its default value is illegal (for example "" for a date parameter), the job won't even start.
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.
If you want the job to abort after encountering 5 rows that does not satisfy the constraint - then you would have to hard code 5 in the Abort After Rows option.chalasaniamith wrote:If you dont pass the parameter does the job abort? that what your saying right?
What I meant is that you cannot pass 5 as a parameter to that option.
Hope this helped.
Aneesh
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
I guess this could be possible, give it a tryDSguru2B wrote:What about UtilityAbortToLog. That will work.
Code: Select all
If PAR_NAME =1 then Incolumn.ColumnA else UtilityAbortToLog('Job Aborted')
Play with the parameters.
Did I understand your question right?
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
If you need to pass the number of rows as the parameter, then the best bet will be to build a Custom Stage using the Abort operator.
I haven't really used it in a live job, but have played with it quite successfully.
Aneesh
I haven't really used it in a live job, but have played with it quite successfully.
Aneesh
Last edited by thebird on Fri Dec 08, 2006 9:45 am, edited 1 time in total.
I take my words back. UtilityAbortToLog wont work inside the px transformer. The only other work around that i can think of at the moment is writing an after job subroutine and check for number of rows in that particular link. If its more than what you want, you can call DSLogFatal() routine or even UtilityAbortToLog from there.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.