Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 15:23:30 GMT

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

With "set record unformatted", FastLoad will treat the file as nothing more than a string of bytes. You must therefore account for every single byte in the file. I assume that you have a fixed-length Unix text file; if so, every line is terminated by a LineFeed (x'0A', a.k.a. "\n"). Add a filler byte to your DEFINE command like so:

DEFINE
       MINE_ID       (CHAR(7)),
       CURR_OWNR     (CHAR(7)),
       CASE_NAME     (CHAR(25)),
       MINE_IND      (CHAR(1)),
       LINE_FEED     (CHAR(1))
       FILE =vcondata;

Good luck!

--wgr

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