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
Reject Handling in DB2 Enterprise Stage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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>
<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>