Hi,
I am doing transformation on decimal value to feed into flatfile
incoming data has field which is decimal(with two decimal places) i need to convert it into integer in COBOL format 9(6)v9(3)
i am using derivation right("0000000000":(column.value*1000),9)
it works fine with some value expect for value like 456783.235
the value it show as 56783e+8 but i am expecting the value
456783235.
can any tel me what want wrong?
issues in data transformation decimal to integer
Moderators: chulett, rschirm, roy
Re: issues in data transformation decimal to integer
Looks like your target field datatype is double/dfloat after the transformation.
Can you try making it Integer 10
Can you try making it Integer 10
Re: issues in data transformation decimal to integer
Its actually varchar(9)divesh wrote:Looks like your target field datatype is double/dfloat after the transformation.
Can you try making it Integer 10
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
VarChar(9) is not big enough - you need at least VarChar(11) - you have nine significant digits, a sign and a decimal placeholder. Where do you expect the third decimal place to come from, given that your source column only has two?
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.
Source column has three decimal places. is there any other way to declare the value.ray.wurlod wrote:VarChar(9) is not big enough - you need at least VarChar(11) - you have nine significant digits, a sign and a decimal placeholder. Where do you expect the third decimal place to come from, given that your source column only has two?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: issues in data transformation decimal to integer
Sorry, I was tricked by this statement in your original post.madhav62 wrote:incoming data has field which is decimal(with two decimal places)
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.