Hi,
We have input data as char & target data as integer.
We are loading data via transformer in Db2 using DB2 enterprise stage.
If input data which is char is valid integer then xfr does implicit conversion and loads it into DB2.
But if input data is invalid integer value then transformer defaults it to '0' and loads it into DB2.
Is there any option wherein we can avoid defaulting of value '0' and abort the job.
Thx in advance.,
Parag
Avoiding Defaulting of invalid data in integer in xfr
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact: