handling Bigint as char datatype-DecimalToString conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray!ray.wurlod wrote:The output data type needs to be string of some kind. You can not prepend zeroes to a numeric data type - they are stored internally in binary format. ...
We were having the output data type as Char
and i saw your lines on the other thread
so we were doing DecimalToString as i have explained in my original post and it was not working.(we were getting only 0's as the output fromray.wurlod wrote:prepend zeroes to a numeric data type - they are stored internally in binary format. ...
DecimalToString(Inlink.column,"fix_zero")
irrespective of the values in the Inlink.column.
)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, then try something like
Code: Select all
Right("00000" : DecimalToString(InLink.MyField, fix_zero), 5)
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.