Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 11:12:09 GMT


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


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



     
  <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