Archives of the TeradataForum

Message Posted: Wed, 12 Jul 2006 @ 16:49:10 GMT

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

<-- Anonymously Posted: Wednesday, July 12, 2006 12:37 -->

If you tell MLOAD the file is TEXT or VARTEXT, x'00' will be treated as a string terminator while parsing the data.

How about making the data fields fixed width and using UNFORMAT?

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