Page 1 of 1

Integer to decimal conversion

Posted: Thu Jul 14, 2011 1:55 am
by dr.murthy
Hi , how to do integer to decimal conversion , since i got a below warning in log When binding input interface field "FIN_VEND_I" to field "FIN_VEND_I": Implicit conversion from source type "int64" to result type "decimal[10,0]": Possible range limitation.

Re: Integer to decimal conversion

Posted: Thu Jul 14, 2011 6:00 am
by netgurutoo
These are only warnings. You can use a Modify stage to change column types from Integer to Decimal. You don't need to worry about unless you have to get rid all warnings in your job. Datastage wil convert for you

Re: Integer to decimal conversion

Posted: Thu Jul 14, 2011 6:02 am
by PhilHibbs
Decimal[10,0] can only go up to 9,999,999,999 whereas the int64 source field might have numbers larger than this. As netgurutoo says, this is just a warning.