Reject Handling in DB2 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
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Reject Handling in DB2 Enterprise Stage?

Post by parag.s.27 »

Hi,

I am using DB2 enterprise stage in the job to load data in DB2.
The job design is very simple i.e. Source Seq file > Transformer > DB2 stage.

I want to have reject handling mechainism for datatype mismatch in DB2 stage.

i.e if target coulumn is integer & if we encounter character data in source the record should be recorded in reject file.

Currently DB2 enterprise stage allows reject link only for upsert strategy and on encounter of invalid datatype it aborts the job and invalid records are not being sent to reject file.

Any help?

Regards,
Parag
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Refer THIS link.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply