Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Apr 2004 @ 15:22:49 GMT

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

Subj:   Re: How to identify which column in TD2621 error
From:   Summers, Scott

What application is returning the error with column number instead of column name?

When I get a 2621 error using either qman or bteq I get the columnname.

For example:

     select cast(sid_desc as byteint) from  mprodv.v_fcc_sid_ref ;
      *** Failure 2621 Bad character in format or data of fcc_sid_ref.SID_Desc.
                     Statement# 1, Info =0
      *** Total elapsed time was 11 seconds.

  <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: 23 Jun 2019