DSXchange

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.

If it's valid syntax, sure you can run it from the stage.