error datatype:floating point decimal

lory · Post by **lory** » Tue Jan 04, 2005 5:55 am

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!

ray.wurlod · Post by **ray.wurlod** » Tue Jan 04, 2005 2:23 pm

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.