Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 16 Mar 2004 @ 16:30:04 GMT

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

Subj:   Re: Mload Trim spaces before loading
From:   Michael Larkins

What you are seeking is automatically provided when the column in the table is defined as VARCHAR. Otherwise, even if you trim off the spaces on the way into Teradata (or any database for that fact), once it hits the CHAR defined column, the field will be padded out to the right with spaces - you don't seem to want this. Therefore, make sure you column is of the varying length and you have it covered.

Michael Larkins
Certified Teradata Master

  <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