Accessing table across all namespace

Question

Question

Confused Developer · May 22, 2017

We have multiple server and multiple namespace.

I have a script having sql query which fetch data from current namespace of a server.

If I want to run the same query on different server to fetch data, but I want to run that script on just one server for all server.

Please let me know how can I proceed.

Discussion (2)1

Log in or sign up to continue

Otto Medin · May 22, 2017

Hi,

A couple of questions, in order to better understand what to recommend:

Is the Caché instance where you're running the script an ECP client of the remote Caché instance?
I can't quite parse "on just one server for all server". Is there a typo in there somewhere?

Cheers,

Otto

0 0

score 0 · Answer 1 · 2017-05-23T14:50:38-04:00

Yes that was typo.. Sorry about that

We have different servers(different IP) where we have ensemble healthshare installed.

And we have a common package LIB which has been mapped through package mapping.

I want a table where I want to insert rows(which I will be fetching from each server.)

Not sure which approach I should follow.