Archives of the TeradataForum
Message Posted: Mon, 26 Jul 2004 @ 15:43:09 GMT
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.
Put extra "delimiter" ('|') to complete the number of fields required for layout.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|