Netezza – Out of Range Error

Reading Time: < 1 minute


760486(253) [2, INT2] out of range (-32768..+32767), “65535”[,]


Query is trying to insert/update value 760486 in the column of a table which has a datatype of smallint or int2 but the value being inserted is greater than the smallint max limit.


Alter the column to int or bigint and try to insert/update the data again.