Hi,
If I have the source as 11.34 I need only the numbers before the decimal, i.e. 11 .
Is there a stage I can use in EE instead of conventionally using the transformer?
Thanks,
Substr of Decimal
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
Hi Ray,
I have used
ME_TGT:int64=int64_from_decimal [trunc_zero] (ME_LOW)
ME_TGT:integer=int32_from_decimal [trunc_zero] (ME_LOW)
ME_TGT=int64_from_decimal [trunc_zero] (ME_LOW)
My source column is Real (40. and my target column is integer(ME_TGT).
The job aborts saying operator conversion not possible, am I missing onthe syntax. Appreciate your time.
I have used
ME_TGT:int64=int64_from_decimal [trunc_zero] (ME_LOW)
ME_TGT:integer=int32_from_decimal [trunc_zero] (ME_LOW)
ME_TGT=int64_from_decimal [trunc_zero] (ME_LOW)
My source column is Real (40. and my target column is integer(ME_TGT).
The job aborts saying operator conversion not possible, am I missing onthe syntax. Appreciate your time.
ALISO
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Real and dfloat are approximate representations of data. Decimal and numeric are exact representations. They are different data types, which is why you experienced what you did. My original response was based on your statement that the data type was Decimal.
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.