Capturing rejects in Oracle OCI stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Maximus_Jack
Premium Member
Premium Member
Posts: 139
Joined: Fri Apr 11, 2008 1:02 pm

Capturing rejects in Oracle OCI stage

Post by Maximus_Jack »

I'm inserting records into oracle oci stage, whenever the insert fails for whatever reason
i need to capture that in a sequential fail of the rejected records, i tried adding a sequential
file at the end of the oracle oci stage but i couldnt find any reject options, can anyone help me?

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

Post by chulett »

In a Server job the reject link goes on the transformer feeding the target, not the target itself.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

FYI - In essence they reject "back up" the link and can then be captured in a later link that is marked as a Reject link or has a constraint that checks the REJECTED link variable.
-craig

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