Archives of the TeradataForum

Message Posted: Tue, 14 Nov 2000 @ 19:55:27 GMT

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

Dara,

you just have to use the appropriate FORMAT Option in your LAYOUT command. Have a look at the manuals, if the datafile is really readable ascii, then try:

.IMPORT INFILE foo.data
LAYOUT lay1
FORMAT Text
APPLY dml1;

and don't use varchar in your fielddef:

.FIELD f3 * char(3);

btw. did you really try fastload to load that data? You have to use SET RECORD UNFORMATTED and no varchar, too.

Dieter

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