Archives of the TeradataForum
Message Posted: Tue, 06 Apr 2004 @ 14:14:42 GMT
Does anybody know how to resolve the column number in the Teradata 2621 error message to the failing SQL ?
I recently had a problem with some SQL which failed with this error number and the message text was 'Bad character in format or data of <tablename> column 21.'
I have worked out where the problem is but I had to go the long-way round, i.e. run my sql multiple times each time adding or removing an individual column until I was able to isolate the column causing the problem.
My failing sql is an insert/select, the select actually queries a derived table which itself is a simple select from a single table. My sql was failing on the insert portion of the processing - the derived table and the outer select themselves run fine.
Some other thoughts:
- the target table only has 12 columns, so it doesn't look like the 'column 21' refers to the column position within the table.
- in the derived table, the failing column is number 20 in my select list.
- neither the derived table nor the outer Select have any GROUP BY or statistical functions which would cause additional fields to be added to the spool files.
I have encountered the same problem on both 5.0.0 and 5.0.1.
Has anyone else come across this before ? Have you been able to resolve the column number to something meaningful within your sql?
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|