Archives of the TeradataForum
Message Posted: Tue, 06 Apr 2004 @ 16:45:54 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023