Archives of the TeradataForum

Message Posted: Tue, 06 Apr 2004 @ 16:45:54 GMT

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

Dave,

I think the error is reported when conversion fails from one datatype to the other. In your case it was the cast statement (cast(sid_desc as byteint).

I had run into the same situtation with our supplier table. Where our supplier Id is defined as alphanumeric (consists of mostly numeric data) in some supplier's case it was 'a12345' the alphabet that was causing 2621 error when I casted supplier Id to integer.

I would always check for columns where there is an explicit / implicit casting is involved. This is the quickest way to find the offending column in a given SQL code.

I hope this helps.

-Shridhar

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