I need to insert some values into a column defined as INTEGER. When I check the table after the load, I can see the numbers have changed and have been assigned a Negative sign by Teradata.
The conversion is as follows
2150272280 is converted to -2144695016
2151317548 is converted to -2143649748
2154078896 is converted to -2140888400
2155779784 is converted to -2139187512
I know that a Integer field can handle data in the range of -2147483648 to 2147483647 and all my problem numbers have a value more than '2147483647'. Is this the reason that the numbers more than the maximum value for the integer are being converted into a negative number. If so, is there a logic how the numbers above the range are converted into a different number.
Thanks,
Pramod
The conversion is as follows
2150272280 is converted to -2144695016
2151317548 is converted to -2143649748
2154078896 is converted to -2140888400
2155779784 is converted to -2139187512
I know that a Integer field can handle data in the range of -2147483648 to 2147483647 and all my problem numbers have a value more than '2147483647'. Is this the reason that the numbers more than the maximum value for the integer are being converted into a negative number. If so, is there a logic how the numbers above the range are converted into a different number.
Thanks,
Pramod