Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2004 @ 15:43:09 GMT

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

Karti:

I tried your mload layout, but it didn't work because of the reason stated below.

input Record Requirements
-------------------------

The total number of fields in each input record must be equal to or greater than the number of fields described in the MultiLoad layout FIELD and FILLER commands.

If it is less, the MultiLoad utility generates an error message. If it is more, the Teradata Database ignores the extra fields.

The last field of a record does not have to end with a delimiter character. It can end with a delimiter character, but it is not required.

Solution:-

Put extra "delimiter" ('|') to complete the number of fields required for layout.

     id|a|b|c|d
     id|a|b||

Mad.

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