Netezza – Out of Range Error

Reading Time: < 1 minute

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.

Resolution:

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