Page 1 of 1

error datatype:floating point decimal

Posted: Tue Jan 04, 2005 5:55 am
by lory
What does mean the following warning:
[i]input1.DSLink43:
When checking operator: Column num_dw floating point decimal
not fully supported. Adjusting scale??[/i]
In Input the field extracted from oracle is a decimal field (num_dwh) without scale!

Thanks for help!

Posted: Tue Jan 04, 2005 2:23 pm
by ray.wurlod
It's just a warning. DataStage expects Decimal data types to have a scale (otherwise it expects Float). So a warning is logged informing you that the "scale" in the metadata is being adjusted, presumably from unknown to 0.
Why a warning and not an informational message? Because it's an unusual event. This is the DataStage philosophy for logging; only usual, or normal, events are logged as informational messages.