Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Numeric overflow while doing UNION
From:   debojit.pal

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020