Any help to fix this thing is appreciated.
Oracle---> join--->sort---->union----->Sequential file.
columnname(Number(15,0)) target(Integer(15.0))
25558 -2345635343
36667 -34567
12345 -45636
I have set the datatype as integer 15,0 in every stage in the flow and i am receiving the above negative values in target. This source column is not transformed through out the flow. It should return the values unchanged.
-----------
Kumar.
Datatype issue:
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
-
- 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:
There's no such thing as Integer(15) - the largest possible signed int32 only has 10 digits. Hence the recommendation to try BigInt.
What happens in binary when you try to store too large an integer is that you get "arithmetic overflow". The most significant bit tends to be set, which signals a negative integer. The answer will almost certainly be wrong anyway. You need to prevent this from occurring by using a data type that is able to handle sufficiently large numbers.
What happens in binary when you try to store too large an integer is that you get "arithmetic overflow". The most significant bit tends to be set, which signals a negative integer. The answer will almost certainly be wrong anyway. You need to prevent this from occurring by using a data type that is able to handle sufficiently large numbers.
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.
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata