Page 1 of 1

datastage senario

Posted: Thu Apr 02, 2009 5:19 am
by prasson_ibm
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.

Posted: Thu Apr 02, 2009 6:37 am
by srinivas.g
in transformer specify constraibt as name='abcd' and
set Abort after rows =1

Posted: Thu Apr 02, 2009 1:43 pm
by Gautam19
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.