Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   How to identify which column in TD2621 error
From:   David Wellman

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?



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

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020