Sybase OC stage - Reject capturing with BASIC transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sri1dhar
Charter Member
Charter Member
Posts: 54
Joined: Mon Nov 03, 2003 3:57 pm

Sybase OC stage - Reject capturing with BASIC transformer

Post by sri1dhar »

I am trying to capture rejects while upserting records into Sybase. I am using the "insert new rows or update existing rows option."

When a record is rejected the REJECTED, REJECTEDCODE are set to 0 in the transformer reject output link. Has anybody else experienced this issue. I appreciate any inputs.

Its a Parallel job with BASIC transformer and SybaseOC stage.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

What link are you providing in the linkname.REJECTED. That linkname should be the one going into the database.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
sri1dhar
Charter Member
Charter Member
Posts: 54
Joined: Mon Nov 03, 2003 3:57 pm

Post by sri1dhar »

DSguru2B wrote:What link are you providing in the linkname.REJECTED. That linkname should be the one going into the database.
Yes, I am using the linkname that is going to the Sybase OC stage.
Post Reply