Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 18:08:28 GMT


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


Subj:   Re: MLOAD - Multiple record types
 
From:   Edelsberg, Philip L

You should be able to set up multiple APPLY statements based on your transaction code:

Apply InsertT1 where TransCode = 'H'
Apply InsertT2 where TransCode = 'D'

See manual B035-2409-121A, Teradata Multiload Reference, Appendix D, page D-2.

To load the same file to a single table you would have to set up the LAYOUT so that the records are redefined with different field names. You'd have to do an Insert for the Header then an Update for the other records. You have to do one action at a time per input record. You can't save all the detail for one header unless you set up an inmod.


Thanks,

Phil Edelsberg, CCP, PMP.
Teradata Certified Master
Northrup Grumman IT
Postal Division



     
  <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: 23 Jun 2019