DSXchange

Hi Prams, I had to do a little digging but I hope this solves your issue. There are two APT variables that work together to contorl commit level - APT_ORAUPSERT_COMMIT_ROW_INTERVAL APT_ORAUPSERT_COMMIT_TIME_INTERVAL By default they are, 5000 (rows) and 2 (seconds) respectively. If you set the row in...

Hi Craig, My apologies for such a tardy response . . . holidays, year end . . . the usual. Anyway, it took me a little digging and experimentation to figure out what you were referring to, "Abort after X rows", as this is not an option on a reject out of an Oracle Enterprise stage or on th...

Thank you for the quick response.

Based on the discussions I have had with our developers, an immediate failure would be desirable.

Hello everyone, I have recently been asked by our developers for a way to abend a parallel DataStage job in the event a row is rejected from an Oracle insert or update using the Oracle Enterprise stage. A constraint violation for example. In my reasearch, it looks as if DataStage only handles two sc...