warning on dfloat to decimal

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
consulting
Participant
Posts: 50
Joined: Fri Dec 21, 2007 3:24 am

warning on dfloat to decimal

Post by consulting »

I am getting warning as "Implicit conversion from source type "dfloat" to result type "decimal[13,2]": Possible range/precision limitation."

Wether it has any impact on data
balaji
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Depends on the data. It's telling you that you are emptying a 10 pound bag into a 5 pound bag and that it may not all fit. The outcome totally depends on what's in the bigger bag.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's an alert message. Not every dfloat number can be represented as decimal[13,2]. The key word in the message is "possible". If you are 100% certain that all your data will fit, then you can ignore this alert message.
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