Skip to content

Netezza – Out of Range Error


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


Query is trying to insert value 720625 in the 25th column of a table which has a datatype of smallint or int2 but the value being iserted is greated than the smallin max limit.


Alter the column to int and try to insert the data again.