Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

Ramu:

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:

     > .LAYOUT REFARENCE_LAYOUT;

     >        .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.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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