Archives of the TeradataForum
Message Posted: Thu, 03 Nov 2005 @ 11:12:09 GMT
Subj: | | Re: 3535: A character string failed conversion to a numeric value. |
|
From: | | McCall, Glenn David |
Have you tried using the "create table ... as ... with data" variation? What does the created table look like using that form of query? Can
you publish the table definitions and your queries (it might make it easier to help you)?
Example:
Create table tst
As (
select *
from the_other_table
)
With data;
Refer to the docs for things like specifying Primary indexes et al.
Good Luck
Glenn Mc
|