Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Jun 2007 @ 12:43:44 GMT

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

Subj:   Re: Mload script to copy data from 1 table to another table in Teradata
From:   McCall, Glenn David

Do you mean copy a table from one system to another? If not, then you can simply do an insert select.

If you really want to use multiload, you will need to first export the data from the source table (e.g. use fastexport). You can export to a file or named pipe. Either way, you then write the script to load the date from the file or named pipe.

There are examples in both the fastexport and mload manuals. You will need to modify the examples to suit your table and system names as well as the record layout in the file/named pipe.

Glenn Mc

  <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: 28 Jun 2020