Rejects from Dynamic RDBMS Stage

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
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Rejects from Dynamic RDBMS Stage

Post by asorrell »

I'm just trying to confirm if I've uncovered another release 8 bug or not.

I'm using a Dynamic RDBMS stage to update an Oracle 11g database. It works well, but I can't seem to get any reject records to come down the reject link off the transformer that feeds the DRS stage (and yes array / transactions size are 1).

I've written a small test job to insert records into a table. On a second run the job does reject the records (insert fails due to pre-existing records) and I see the messages in the director, but nothing comes down the reject link.

Any ideas? Can anyone confirm this works on 7.5?
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Top
smeliot
Participant
Posts: 19
Joined: Sun Mar 18, 2007 7:31 pm

Post by smeliot »

I'm having the same problems. The RDBMS stage is rejecting my rows (and rightly so - there's a constraint error), but my reject link doesn't get anything.

Have you found a solution yet ?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”