SQL query involving multiple IDS instances
A user with IDS 9.40 UC5 and 11.50 UC5 instances on separate hosts asked how to query both in one SQL statement. Clifford Burton and Art Kagel gave the database@server:table syntax in a join. The user added the other instance to sqlhosts and the service to /etc/services, and it worked.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all, We are currently running two IDS instances in separate SLES hosts: one is a 9.40 UC5 and the other one is a 11.50 UC5. We came across the task of getting data from databases hosted in both instances in a single SQL query. Looking at the IBM documentation didn't give us a clear solution. Is it possible? Do we need any software or special connectors to achive that? Thanks in advance
Select db1@instance1:table local, db2@instance2:table remote where local.col = remote.col; Sqlhosts entries may need to be defined. Permissions etc . But that is the sql syntax On May 24, 2012 4:45 PM, "DEPARTAMENTO SISTEMAS" <sistemas.dgft@minhap.es> wrote: > Hi all, > > We are currently running two IDS instances in separate SLES hosts: one is a > 9.40 UC5 and the other one is a 11.50 UC5. > > We came across the task of getting data from databases hosted in both > instances in a single SQL query. > > Looking at the IBM documentation didn't give us a clear solution. > > Is it possible? Do we need any software or special connectors to achive > that? > > Thanks in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf302d4c4e575a8f04c0c30adc
Select ....
FROM remote_db@remote_servername:remote_table as rmt, local_table as lcl
WHERE rmt.keycol1 = lcl.keycol2 .......
;
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Thu, May 24, 2012 at 2:45 AM, DEPARTAMENTO SISTEMAS <
sistemas.dgft@minhap.es> wrote:
> Hi all,
>
> We are currently running two IDS instances in separate SLES hosts: one is a
> 9.40 UC5 and the other one is a 11.50 UC5.
>
> We came across the task of getting data from databases hosted in both
> instances in a single SQL query.
>
> Looking at the IBM documentation didn't give us a clear solution.
>
> Is it possible? Do we need any software or special connectors to achive
> that?
>
> Thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae934099f20a88d04c0c54973
Just added the entrance to $INFORMIXDIR\\\\etc\\\\sqlhosts refered to the other instance and the service in /etc/services and worked like a charm. Thanks a lot mates!