error calling conversion routine decimal_from_string

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vitumati
Participant
Posts: 27
Joined: Tue Sep 07, 2010 11:38 pm

error calling conversion routine decimal_from_string

Post by vitumati »

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
Abhinav
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply