Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2000 @ 21:50:44 GMT

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

Subj:   Re: MLOAD ERROR 2679
From:   Michael Larkins

Hi Gloria:

As the commerical goes, "This is a tuffy." Only because there is no 2679 in my DBC.Errormsg table.

However, if I were you, I would first verify that the data types are exactly the same for the column "amt." If they are the same, verify all the columns prior to it and make sure that they are the same. When I say, make sure they are the same, I am talking about the .LAYOUT definition. Also make sure that the two CREATE TABLE statements on the different systems are the same, use SHOW TABLE.

Here is another suggestion to make sure they are the same. In your .LAYOUT use a .TABLE instead of several .FIELD statements. This will automatically generate the definition. Another option is to use a self defining INSERT. It is written simply as INSERT INTO .*;

First, I would verify the CREATE TABLES and then examine the .LAYOUT.

Hope this helps get you started and good luck,


  <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