Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 May 2005 @ 17:32:01 GMT


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


Subj:   Re: Teradata connection to two machines
 
From:   Bob Hahn

Assuming the question concerns copying data rather than the definition...

In V2R6, via UDFs, this CAN be done via SQL (which could be issued from BTEQ, SQL Assistant, etc.).

A prototype is described in the Orange Book "Facilities and Techniques for Event Processing". That prototype UDF uses CLI to issue SQL against another Teradata instance. The second example shows how the extract, transport, and apply can be parallelized--multiple parallel queries return multiple answer sets which are applied in parallel to the target via multiple UDF instances.

Without UDFs, there are various well known approaches--select to a file via SQL or FastExport then load from that file via SQL or a Teradata utility perhaps FTP'ing the file first. The landing can be avoided via use of Named Pipes (BTEQ/FXP to BTEQ/FDL/MDL/TPump), OLELOAD, Message Queues, a database, or other custom approaches..



     
  <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