Archives of the TeradataForum

Message Posted: Fri, 31 Oct 2003 @ 19:28:42 GMT

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

You should ues FORMAT TEXT. If you use no format statement the default format is FastLoad, which suppose binary type data with a two- byte length field at the begging of each record. You should also be able to use FORMAT UNFORMAT, I think.

.IMPORT INFILE C:\fast\INPUTDAT.TXT
.LAYOUT UsingData
.FORMAT TEXT;

I have also had success adding the phase DROP LEADING AND TRAILING BLANKS; on the .FIELD line so that it looks like this:

.LAYOUT UsingData;
.FIELD scandesc * char(10)
DROP LEADING AND TRAILING BLANKS;

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