Stringtodecimal conversion error

keshav0307 · Post by **keshav0307** » Fri Sep 22, 2006 9:05 pm

I have input of char( 8 ), how to convert it to decimal ( 8,8 ) in a transform stage.
it's working fine to convert decimal ( 8,0 ).

kris007 · Post by **kris007** » Fri Sep 22, 2006 10:00 pm

What happens when you try to convert it to decimal[8,8]? Does it give any error?

ray.wurlod · Post by **ray.wurlod** » Sat Sep 23, 2006 3:32 pm

Precision must be at least one larger than scale. Decimal(8,8) is not an acceptable formulation; you need at least Decimal(9,8) to accommodate eight decimal places.

keshav0307 · Post by **keshav0307** » Sun Sep 24, 2006 5:45 am

What happens when you try to convert it to decimal[8,8]? Does it give any error?

it convert any values to 0.00000000

keshav0307 · Post by **keshav0307** » Mon Sep 25, 2006 3:01 am

Another thing i noticed is :
when the input is 00000000, StringToDecimal does not work.

pankajg · Post by **pankajg** » Mon Sep 25, 2006 4:01 am

Ray, why does the precision needs to be larger than scale?? Any particular reason, and if the scale=percision what's the problem in there?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 25, 2006 2:57 pm

It's just something I've noticed over the years. Decimal[N,N] should be able to represent numbers between zero and less than 1.0, theoretically, but it seems that some implementations need to be able to specify that there is a digit to the left of the decimal place holder.