Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: CAST error: 5355
From:   DWellman


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.



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

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