Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Jul 2002 @ 18:30:53 GMT

  <Prev Next>  
Next> Last>>  

Subj:   TPUMP-Multiple table insert/update
From:   Anomy Anom

<-- Anonymously Posted: Thursday, July 25, 2002 14:24 -->


I want to know if we can load multiple tables in a single TPUMP script.

1. Single input file with multiple record layouts (Variable Record) file-load different tables depending on the record types.

2. Single input file with a single LAYOUT having the data to load multiple tables.

Are both the cases explained above are possible? If so please give illustration.

The other question I have is How many TPUMP jobs can run in parallel? We are planning to have a continously running task on the mainframe executing TPUMP utility.

Please advise.

Thanks & Regards

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020