my source is mainframes im getting the data data type is char but i need to load it in Double data type
i used StringToDecimal convertion as per design doc but im getting expected output with warnings
plz help out from this problem
Xfmr_ICLIC_Load,3: Conversion error calling conversion routine decimal_from_string data may have been lost
Xfmr_ICLIC_Load,1: No more conversion warnings will be issued
error calling conversion routine decimal_from_string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This message suggests that the precision of your floating point data type is insufficient to handle the maximum number of digits possible in the CHAR data type. Note that this does not relate to the actual number of digits in the CHAR field, it relates to the size of the CHAR field. It might also be useful to trim white space from the CHAR (perhaps into a VarChar data type stage variable) before attempting the conversion.
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.