Converting BigInt(Int64) to Integer(Int32) in Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Tue Oct 30, 2007 8:33 am
- Location: Chennai
Converting BigInt(Int64) to Integer(Int32) in Modify Stage
Can i have the syntax/example for Converting BigInt(Int64) to Integer(Int32) in Modify Stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
OutputColumn:int32=InputColumn
Code: Select all
OutputColumn:nullable int32=InputColumn
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: 13
- Joined: Tue Oct 30, 2007 8:33 am
- Location: Chennai
ray.wurlod wrote:orCode: Select all
OutputColumn:int32=InputColumn
Input column is of data type int64. This will generate "possible loss of precision" war ...Code: Select all
OutputColumn:nullable int32=InputColumn
I get a warning when i tried to implement the idea. The warning needs to be avoided. What needs to be done here??
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read the remainder of my post, which deals with suppressing the warning.
Premium membership costs less than 30c (Rs12) per day. These funds are totally devoted to assisting with the hosting and bandwidth costs incurred by DSXchange. It is a worthwhile investment.
Premium membership costs less than 30c (Rs12) per day. These funds are totally devoted to assisting with the hosting and bandwidth costs incurred by DSXchange. It is a worthwhile investment.
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.
-
- Premium Member
- Posts: 5
- Joined: Tue Oct 09, 2007 6:29 am
- Location: Chennai