Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Nov 2005 @ 22:47:03 GMT


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


Subj:   3535: A character string failed conversion to a numeric value.
 
From:   Rice, Roberta

Help!

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.

I have checked temp elements against prod elements to make sure I didn't fat finger the definitions and they all look fine. I have tried the insert using all elements, only inserting to one element and inserting to several random elements - each time using different elements. No matter what is in my select statement, I get the same error.

Any ideas?


Roberta "Bert" Rice
RSS Common Key
Technology Services - Topeka



     
  <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