Avoiding Defaulting of invalid data in integer in xfr

[parag.s.27]

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

[Maveric]

Try using IsValid() in transformer. If it is not a valid integer sent the record down to a reject link and abort the job after one reject by setting the condition "Abort after rows" to 1 in transformer.