Manual abort of a job

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
vinayc
Participant
Posts: 12
Joined: Wed Nov 14, 2007 4:38 am

Manual abort of a job

Post by vinayc »

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
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

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'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is this, indeed, a Transformation Extender (TX) job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

If it is TX use the FAIL function.
Post Reply