Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 28 Feb 2007 @ 20:37:58 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Error for .import with filter condition
From:   Michael Larkins


I am not sure about the space error, but from what you have shown me below, your LAYOUT is not correct. I have included only the lines that need to be changed to redefine the buffer:


     >        .FIELD IN_type_b                  2 VARCHAR(3);
     >        .FIELD IN_type_c                  2 VARCHAR(10);
     >        .FIELD IN_type_d                  2 VARCHAR(2);
     >        .FIELD IN_type_e                  2 VARCHAR(1);

Furthermore, I do not know what your SQL looks like, but I would be doubtful that you are using your IN_type_ and potentially IN_code_ values in SQL. If this is true, instead of defining them as FIELD, they SHOULD be FILLER. All FILLER values are not sent to Teradata in a block. If you are having space issues in the database, it might be due to sending a lot more data down than you need. This could be true of your indicator field as well. These changes will make Mload a lot more efficient on space and faster by sending further blocks of garbage.


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020