Archives of the TeradataForum
Message Posted: Wed, 03 Dec 2003 @ 18:08:28 GMT
You should be able to set up multiple APPLY statements based on your transaction code:
Apply InsertT1 where TransCode = 'H'
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.
Phil Edelsberg, CCP, PMP.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|