records getting rejected when inserting in to oracle 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
amreesh_singh
Participant
Posts: 15
Joined: Tue Aug 26, 2008 5:07 am

records getting rejected when inserting in to oracle stage

Post by amreesh_singh »

Hi,

The records are read from seq file and then inserted in to oracle table.
records are imported successfully but while inserting the records its rejecting them. I am not getting any warning in the log , its showing inserted: 0 ; updated : 0 ; rejected :9
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Add a reject link and examine the SQL codes that are added to the output stream on rejects in order to determine why these records are being rejected.
Top
Post Reply

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