Archives of the TeradataForum
Message Posted: Wed, 02 Nov 2005 @ 22:47:03 GMT
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.
Roberta "Bert" Rice
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|