Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 18:45:06 GMT


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


Subj:   Re: CAST error: 5355
 
From:   DWellman

Hi,

Try using the TYPE function which will tell you the data type of each column in each Select list. I'd also suggest that for testing you include a "GROUP BY 1,2,3" within each select so you only get one row back. Check that the DBMS isn't doing an implicit cast for you. I've recently sorted out something similar and found that a TIME(0) column was being cast to an INTEGER. That took me most of the day to sort out but once I used the TYPE function and realised the problem I got it fixed in about 20 minutes.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 27 Dec 2016