abort job and capture rejcts

[dodda]

Hello

I have a scenario where i have to abort the job if i see any rejects out of oracle stage.I am doing only inserts in the oracle stage. So i have changed the property in the oracle stage to ouput reject rows=true. But the requirement is i need to capture the first rejected record from the oracle stage in a file so that i can send email to the support team and then i have to abort the job.
my job design is as below


seqfile----trf----oracle------trf---seqfile

i used abort after 1 row property in the transformer coming out of orcle. the job is getting aborted but when i see the rejected File it is empty. Is there a way that i can achiveve it.

Thanks

[ray.wurlod]

Try setting the abort count to 2, so that at least one row gets out.

[dodda]

Hello Ray,

Thanks. I tried that and the job is getting aborted but i dont see the first row written to the file instead a zero byte file is produced. I even tried using peek stage and from peek stage i have written to a Seq File. But in vain. Is there another way.

Thanks for the help

[Sainath.Srinivasan]

As DataStage runs in parallel mode, the abort may kill the process before the data is flushed into the file.

Simplest way will be to use a peek stage and pick the data from the logs.

[dodda]

Hello sainath,

Thanks for the reply. Can you help me how to pick the data from the log.