Hi,
SELECT t1.col1, t2.col2
FROM db1@server1:table1 t1,
db2@server2:table2 t2
WHERE t1.comm_col = t2.comm_col;
This query can be used in Informix database to access tables in different servers, but can we use the same query in a single Inforrmix stage to join two tables in different informix servers?
Please let me know if any works on same.
Informix stage in Datastage version 8
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am