Parsing error
Posted: Fri Nov 10, 2006 7:04 am
Transformer_2,0: Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
Parsing parameters "" for schema type "decimal": Expected precision; got: <eof>
When I am running my job I get the error, I use some stringtodecimal functions in the job. I am not understanding why I get the error.
I use
Also, is there any alternate ways to achieve the same.If ( TrimLeadingTrailing(DSLink4.DEPN_NBR) = '' ) then 999 else If (Isvalid( "decimal", StringToDecimal(TrimLeadingTrailing(DSLink4.NBR)))=0) then 999 else StringToDecimal(TrimLeadingTrailing(DSLink4.NBR))
NBR is a CHAR column of length 3 and I am converting it to decimal(3,0).I am using the similar derivation for few other columns also.
One more doubt, is there any limit for the constraints as far as memory consumption is considered, can I change that setting?
Thanks in advance,
Ajith