StringToDecimal function - producing warnings

[Titto]

Hi,

I am getting following error in one my job, the same job ran fine in other DS environment with out any error with same data - what could be the reason.
Operating system AIX 5.0 in both DS environments.

Code: Select all

Conversion error calling conversion routine decimal_from_string data may have been lost

Any info/help is appreciated!

~t

[ArndW]

What is the string contents and what is the decimal column definition. Have you checked the other environment to see if you have a message handler set for that that job?

[Titto]

Hi Arndw,

verified other environments, there are not message handlers for those warnings.

basically in those jobs programmer converting a Varchar field to a Number value using StringToDecimal function but we changed that process to use AsInteger function as we know that the source data will have numeric values.

Thanks

[ray.wurlod]

Check the data types, in particular the string length (or max length) and the decimal precision and scale. Are these the same in both environments?

[Umberto]

Try "StringToDecimal(Trim(InputField))".......

[thuan]

You also need to check whether the input is not blank or not is null.
The warning is saying that you are applying the function on non numeric varchar.

[ray.wurlod]

No it isn't. It's saying that there are too many digits in the value.