datastage senario

prasson_ibm · Post by **prasson_ibm** » Thu Apr 02, 2009 5:19 am

Hi,
I have two columns in the source
cust name ,cust id
xxxx,01
yyyy,02
zzzz,03
abcd,04
and i want the job to be aborted when the cust name is "abcd".
So please help me to achieve this in datastage EE

Thanks in advance.

srinivas.g · Post by **srinivas.g** » Thu Apr 02, 2009 6:37 am

in transformer specify constraibt as name='abcd' and
set Abort after rows =1

Gautam19 · Post by **Gautam19** » Thu Apr 02, 2009 1:43 pm

I was trying the same sometime back and this topic helped.

viewtopic.php?t=126232&highlight=Abort+after+rows

This is for aborting the job as well as capturing the unwanted record.