Integer to decimal conversion

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
dr.murthy
Participant
Posts: 224
Joined: Sun Dec 07, 2008 8:47 am
Location: delhi

Integer to decimal conversion

Post 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.
D.N .MURTHY
netgurutoo
Participant
Posts: 6
Joined: Wed Mar 09, 2005 9:35 am

Re: Integer to decimal conversion

Post 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
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Re: Integer to decimal conversion

Post 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.
Phil Hibbs | Capgemini
Technical Consultant
Post Reply