Archives of the TeradataForum

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

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

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>>