Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: MLOAD of a file with multiple record types
 
From:   Nomula, Madhukar

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023