Reject on zero delete from Oracle enterprise 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
kamesh_sk
Participant
Posts: 43
Joined: Fri May 27, 2005 7:58 am

Reject on zero delete from Oracle enterprise stage

Post by kamesh_sk »

HI ,

Iam looking for some explanation on the behaviour of Oracle enterprise stage .
Iam issuing a delete command to the oracle stage and i also have a reject link out from the oracle stage. When there are no delete happening, the oracle returns - No records or zero records deleted. It is not considered to be a failure. But the oracle stage captures those records which did nto find any matchinig key in the table and passes them through the Reject link.

IS this a known behaviour??

What should i do to make the oracle enterprise stage to consider the zero records deleted reply from the database to consider as success and not as failure.

Any comments / Help is much appreciated.

Thanks Very much

Kamesh
Post Reply