Search found 3 matches

by coolbin81
Tue Mar 10, 2009 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion from string to decimal
Replies: 2
Views: 2504

Conversion from string to decimal

Hi all, In one of my jobs, i am converting a field from string to decimal and then using this in the constraint. For eg: StringtoDecimal(Trim( Inputfield )) <> 0.0 I am getting the following warning message in the job: Conversion error calling conversion routine decimal_from_string data may have bee...