Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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?


Cheers,

Dave

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



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