Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 29 Apr 2005 @ 17:27:12 GMT

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

Subj:   Re: Teradata connection to two machines
From:   Hough, David A

It's not possible to connect two systems in BTEQ, but I've seen people do it in MS Access with two linked tables. The users involved were trying to move data from one system to another, and did an insert select in MS Access to make it happen. For low data volumes it wasn't bad.

A caution: these same users were also running some queries in MS Access (single and dual system) and ran into severe performance problems. If MS Access is unsure of how to do the query remotely, it will spool the base tables to the PC and do the query locally. Ouch!

/dave hough

  <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: 15 Jun 2023