Reject records for Oacle OCI 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
philip_prasanth
Participant
Posts: 3
Joined: Mon Oct 19, 2009 8:51 am
Location: asd

Reject records for Oacle OCI stage

Post by philip_prasanth »

Hi,

I have a requirement like if the records and getting dropped while loading the target oracle table using Oracle OCI stage in Datastage Px 8.1 the job should fail.
I am not using the reject property of the stage, but if any records are silently dropping because of NULL constraints or anything , then the jobs should fail.
Job Design :- Source Oracle OCI stage --> Transforme --> Target Oracle OCI stage.
At present this is not happening, it will try to load the records and if it fails then it silently drop the records and remaining the records will be loaded and the job showing it as completed.

Can anyone please help me on this.

Reg
Prasanth
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Moved your second post, too.

:!: Please edit both of your posts (yes, you can do that) to add the DataStage version, O/S and to set the Job Type to Parallel, information that can be important in getting you a proper answer.

Thanks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply