Multi Server Query

palmeal · Post by **palmeal** » Thu Oct 14, 2004 8:23 am

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.

kduke · Post by **kduke** » Thu Oct 14, 2004 8:50 am

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.

chulett · Post by **chulett** » Thu Oct 14, 2004 8:51 am

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).