Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
zulfi123786
Premium Member
Posts: 730 Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore
Post
by zulfi123786 » Fri Nov 20, 2009 1:32 am
Is there any function to abort the job from within a transformer stage, if not then how can this be best achieved?
satish.raghavan
Participant
Posts: 22 Joined: Tue Jul 21, 2009 4:45 am
Location: Chennai
Contact:
Post
by satish.raghavan » Fri Nov 20, 2009 2:25 am
Open the Transformer there you have transformer stage constraints.
Give the constraints and u have a coulmn Abort after where u have to specify the job to be aborted after 50 lines.
Eg. assume a reject condition
ABORT AFTER 50 LINES assume.
Thanks & regards
Satish R
satish.raghavan
Participant
Posts: 22 Joined: Tue Jul 21, 2009 4:45 am
Location: Chennai
Contact:
Post
by satish.raghavan » Fri Nov 20, 2009 2:30 am
You can also use a BASIC Transformer where u can give the abort condition in stage variables .
U have to declare this condition in stage variable accordingly in a basic transformer
If <<CONDITION><Eg. @INROWNUM >50>> Then UtilityAbortToLog('Job Aborted') Else <CONDITION>
Thanks & regards
Satish R
satish.raghavan
Participant
Posts: 22 Joined: Tue Jul 21, 2009 4:45 am
Location: Chennai
Contact:
Post
by satish.raghavan » Fri Nov 20, 2009 4:17 am
Sorry for using U. i meant You. Please change accordingly.I was Fast typing mistake.
Sorry
Thanks & regards
Satish R
ds_ashish
Participant
Posts: 15 Joined: Thu Nov 23, 2006 12:30 am
Post
by ds_ashish » Fri Nov 20, 2009 4:30 am
Hi,
Do you have any specific condition to abort your job?
If yes, then please explain it.
Thanks in Adv.
Ashish
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Nov 20, 2009 7:46 am
satish.raghavan wrote: Sorry for using U. i meant You. Please change accordingly.I was Fast typing mistake.
Just for the record, you
can go back and edit your own posts after the fact. To paraphrase Apple - there's a button for that.
-craig
"You can never have too many knives" -- Logan Nine Fingers