 |
 |
Archives of the TeradataForum
Message Posted: Fri, 29 Apr 2005 @ 17:27:12 GMT
| 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
| |
