DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vinayc
Participant



Joined: 14 Nov 2007
Posts: 12

Points: 106

Post Posted: Wed Mar 19, 2008 8:16 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi,

I am trying to abort the job on the basis of 1 condition. If that condition is not satisfied, the job should get aborted.

EX: If 'SQLcode' column value is not equal to 0 then job should get aborted.

Can anyone suggest the solution for this??
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5242

Points: 26357

Post Posted: Wed Mar 19, 2008 10:00 am Reply with quote    Back to top    

Dont you have a option in Transformer with 'Abort after n rows'?
Pass the record with the above mentioned condition to that newly link. And include the Option that I specified as well for 1 record.

_________________
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Wed Mar 19, 2008 4:59 pm Reply with quote    Back to top    

Is this, indeed, a Transformation Extender (TX) job?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
janhess
Participant



Joined: 18 Sep 2003
Posts: 201
Location: UK
Points: 950

Post Posted: Thu Mar 20, 2008 3:06 am Reply with quote    Back to top    

If it is TX use the FAIL function.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours