While using the following command :
DecimalToString(lReadInput.NRx1,"fix_zero,suppress_zero")
I m getting the following warning:
"Transformer_0,0: Conversion error converting input field NRx1 to output field NRx1, data may have been lost"
My input datatype is decimal(9,3) and output datatype is varchar(9)
DecimalToString warning in job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well done.
In words, the string needs nine characters for the nine significant digits (precision of the Decimal data type), plus one for the sign and one for the decimal point character. That's a total of eleven characters. The VarChar needs to be at least this large.
In words, the string needs nine characters for the nine significant digits (precision of the Decimal data type), plus one for the sign and one for the decimal point character. That's a total of eleven characters. The VarChar needs to be at least this large.
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.