Archives of the TeradataForum
Message Posted: Fri, 26 Oct 2012 @ 14:22:22 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|