DSXchange

Hi Folks

I read numeric fields in input . The length of the field is 3 , if iam passing an Integer of length 4 , the record is not truncated . Is there an Env Variable that controls this behaviour. What is the workaround

Delimited or fixed-width source? If delimited there's nothing; int32 can have up to 10 digits. Your job will need to enforce the business rule downstream. Or you could declare it as string[3] for the import, and convert to int32 subsequently.

Hi Ray

We have input as Comma delimited. Truncation is also ruled out due to other business requirement , now the way we are doing is read it as a String[3] to the xfm and use the Len functions to reject the record.