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>>