DSXchange

Is it possible to query multiple (Sybase) servers in one query in one statement from DataStage (same concept as SQL Server linked servers).

I have 2 servers and I would like to be able to write some code that will do a join between 2 tables on both servers at the same time. I would then like to pass the result set back to DataStage.

We have done this in SQL Server and Oracle. I assume this is not a problem in Sybase. If you create a dblink then you can use it in a user defined query.

Welcome aboard! :D

Not via DataStage directly. You'll need to handle this in your database itself. In Oracle, for example, via database links to the 'remote' database(s).