Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2001 @ 13:14:52 GMT

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

Subj:   Re: Problem with Insert
From:   Ken Hansen


I had a similar problem nearly a year ago and am having difficulty remembering the solution. I think it was data format or the number of columns.

You said it works sometimes but not others: was the data content the same or refreshed? The insert might cope with inputting numbers from a character field into an integer field but fail and think the whole source invalid if the first record includes alpha characters in that field.


As no records are taken from source2 after source1 then try a simple Insert into database1.target_table select * from database2.source2_table;

My suspicion is that the format of data in source2 is not the same as that required for the destination.

In that case either change source2 or create a view of source2 transforming the data format as necessary e.g. cast as ..... Then insert into ..... From view.....

Ken Hansen

  <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