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
Import of Numerical fields
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Integer Length
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.
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.