Archives of the TeradataForum

Message Posted: Tue, 06 Apr 2004 @ 14:14:42 GMT

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

Hi all,

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?

Cheers,

Dave

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

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