Integer to decimal conversion
Moderators: chulett, rschirm, roy
Integer to decimal conversion
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.
D.N .MURTHY
-
- Participant
- Posts: 6
- Joined: Wed Mar 09, 2005 9:35 am
Re: Integer to decimal conversion
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
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: Integer to decimal conversion
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.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant