Archives of the TeradataForum
Message Posted: Tue, 16 Mar 2004 @ 16:30:04 GMT
| 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.
Certified Teradata Master