Archives of the TeradataForum

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

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

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