Archives of the TeradataForum

Message Posted: Fri, 27 Dec 2002 @ 20:27:31 GMT

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

How are you formatting the data? VARCHAR must have a VLI before contents.

Input format to Inmod routine is not necessarily related to input format to MLOAD. Inmods can change the format from anything to something readable by MLOAD. Your inmod can read a line, separate fields -in your example you can easily identify fields in your inmod, by detecting '|'s- and format them as needed by MLOAD. So, you can read variable length text and add VLIs, or just pass fieds as fixed length, adding spaces in the process.

Good luck!

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