Archives of the TeradataForum
Message Posted: Wed, 20 Jun 2007 @ 12:43:44 GMT
| 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
| 
