Archives of the TeradataForum
Message Posted: Wed, 17 Jan 2001 @ 13:14:52 GMT
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.....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|