I have a number of requirements for extracting and combining data from multiple hosts.

Currently I do this by running a query on each host, then combining the data by program.

I would like to be able to write a single query (or script) to achieve this. More flexible.

Can you suggest how to achieve this?

Gregory,

I'm afraid that what you want to do is only possible if all the databases are defined in the same configuration file, so that they can all be accessed throw a single session. Than only makes sense if you are using local sessions (file sharing). Is that the case ?
--
Fernando Dias
[Team Elevate]

Gregory


Its pretty much as Fernando says - you can't cross session boundaries in SQL. What can be done depends on wether this is an ad-hoc or regular requirement. What may be possible is to create something (either using publishing, export/import or streaming) to give a separate database which would have all of the info in it that you need which could then be queries in its own session.

It would not be trivial to set up hence if ad-hoc probably not worth trying.


Roy Lambert

Gregory,

<< I have a number of requirements for extracting and combining data from multiple hosts.

Currently I do this by running a query on each host, then combining the data by program.

I would like to be able to write a single query (or script) to achieve this. More flexible.

Can you suggest how to achieve this? >>

Unfortunately, you can't do so using straight SQL.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks for replies. I will shortly be looking at database replication via publish and when I have more knowledge about how that works, see if I can import just the info I need from a Publish stream.

Tim Young [Elevate Software] wrote:

Gregory,

<< I have a number of requirements for extracting and combining data from multiple hosts.
Currently I do this by running a query on each host, then combining the data by program.
I would like to be able to write a single query (or script) to achieve this. More flexible.

Can you suggest how to achieve this? >>

Unfortunately, you can't do so using straight SQL.

Gregory,

<< Thanks for replies. I will shortly be looking at database replication via publish and when I have more knowledge about how that works, see if I can import just the info I need from a Publish stream. >>

If you need help, just ask.  The replication is pretty easy to use for situations like this, but there are still a lot of ways that it can trip you up.

Tim Young
Elevate Software
www.elevatesoft.com