 |
 |
Archives of the TeradataForum
Message Posted: Thu, 03 Nov 2005 @ 11:12:03 GMT
| 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
| |
