Archives of the TeradataForum

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

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

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>>