Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 11:12:03 GMT


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


Subj:   Re: 3535: A character string failed conversion to a numeric value.
 
From:   Victor Sokovin

  I have created a temp table which is identical to a prod table. I need to insert into the temp table certain records from the prod table for further processing outside of teradata. The create works fine. The insert produces the following error: 3535: A character string failed conversion to a numeric value.  


Just a guess. Are there any DEFAULT values in your column definitions which are based on user/session/system parameters?

I could think of a situation which fits in your scenario: numeric column defined with the DEFAULT set to some substring of USER (USER as a reserved word; check it by issuing SELECT USER, and you'll see what I mean). Now, if on PROD that substring is always numeric then everything works fine there. On the test DB, user naming conventions could be different from PROD, as a result of which you might get 3535.

Context dependent default values are often used for auditing purposes.


Regards,

Victor



     
  <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: 15 Jun 2023