Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 18:21:29 GMT

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

I don't believe that it exists.

However, if the data is all ASCII, you could load the data into a single column table and then parse it in SQL or use sonething on your load machine to convert it into fixed width.

MLOAD (and FASTLOAD and FASTEXPORT) are based on the mainframe philosophy of predefined fixed width fields, not UNIX/Windows variable length fields.

Glen

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