Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2012 @ 19:03:46 GMT


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


Subj:   Re: Numeric overflow while doing UNION
 
From:   Clark, Dave

Sughesh-

For UNIONs, the data type and size of the columns in the resulting data set is determined by the column definitions in the first query of the UNION.

You will need to CAST the columns to support the larger value.


-dave.clark



     
  <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