rejected data capture in seperate file

[Gaurav.Dave]

Hello Friends,

I am trying to catpture "rejected data" while DB2 API stage as target while with "insert the records without clearing" option. I am using PX enivornment. I am using straight mapping in x'former.

I can see "rejected data" information inside DataStage Director logs. Is it anyway, while using DataStage PX, to capture rejected data information into the file?...So that I can format it well and send to my USERS.

This is because If the number of rejected data are small then its ok to manually do it from DS Director log...but in case the rejected data numbers high then its become hard to track it down..

Thanks for your help,

Gaurav

[kcbland]

Place a sequential file stage under your DB2 UDB API stage and right-click draw a reject link to the sequential file stage. See the error message?

Sucks, don't it?