Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2012 @ 14:22:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sugesh,

Numeric Overflow occurs when you try to insert a numeric value occupying more bytes into a column which cannot hold those many bytes. For example if you try to insert 1,000,000 into a smallint or byteint column you will get this error. It is not because of the Union operation itself.

To rectify this error, you need to find out what all are the numeric columns in your target table. Then, try matching the datatypes with the corresponding source columns. Once you find the mismatch, you can change the target column and rerun the union query.

Thanks,

Debojit.

	<Prev	Next>		<<First	<Prev	Next>	Last>>