How to abort a job from within a transformer stage

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

Post Reply
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

How to abort a job from within a transformer stage

Post by zulfi123786 »

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 »

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 »

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 »

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 »

Hi,
Do you have any specific condition to abort your job?

If yes, then please explain it.
Thanks in Adv.
Ashish
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply