Informix stage in Datastage version 8

[Sridhar Sivakoti]

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.

[chulett]

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