Hi All :D ,
I am getting the following warning during conversion of a string(9) to decimal(9)....I am using StringToDecimal(colName) function in transformer Stage.
t3xfrmIIINQ0,2: Conversion error calling conversion routine decimal_from_string data may have been lost.
Can anybody suggest a workaround as i have to use a transformer only and also cannot increase my datatype length...
Thanks in advance for Help.......
conversion warning :---decimal_from_string data lost
Moderators: chulett, rschirm, roy
Re: conversion warning :---decimal_from_string data lost
Why cant u trim the record for spaces and then convert it ...ajmore wrote:Hi All :D ,
I am getting the following warning during conversion of a string(9) to decimal(9)....I am using StringToDecimal(colName) function in transformer Stage.
t3xfrmIIINQ0,2: Conversion error calling conversion routine decimal_from_string data may have been lost.
Can anybody suggest a workaround as i have to use a transformer only and also cannot increase my datatype length...
Thanks in advance for Help.......
I dont know whether it is mandatory .. will help u in case of leading n trailing spaces causing the problem
Code: Select all
StringToDecimal(TrimLeadingTrailing(colName))
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's really an informational message that you seem always to get with decimal_from_string() even when the conversion will always be good; use a message handler to demote it to informational.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.