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.
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?
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.