Scale of decimal column

jzparad · Post by **jzparad** » Tue Mar 29, 2005 6:18 pm

I'm getting the following error in a transformer stage

Scale of Decimal column IATE_PERC must be in the range 0 to 1

when defining a column as follows:
SQL Type: Decimal
Length: 1
Scale: 3

I've found a reference to a similar problem <a href=viewtopic.php?t=82493&highlight=Scale+o ... mn>here</a>
but it claims that this was a bug in 5.1 and should have been fixed since. I'm using 7.5.

Does anyone have more information on this?

davidnemirovsky · Post by **davidnemirovsky** » Tue Mar 29, 2005 6:38 pm

SQL Type: Decimal
Length: 1
Scale: 3

If the length of the column is 1, then where do you expect the remainder to be stored?

Try increasing the length of your column.

jzparad · Post by **jzparad** » Tue Mar 29, 2005 9:32 pm

Oops!

Thanks David

davidnemirovsky · Post by **davidnemirovsky** » Tue Mar 29, 2005 11:00 pm

No problem jzparad, we all make silly mistakes at one time or another.