Archives of the TeradataForum
Message Posted: Wed, 04 May 2005 @ 17:32:01 GMT
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..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|