RE: Select from 2 Servers
Guido-
If you want to read data on server#1 from server#2, try this:
Select * from xx1@server#1:abc
Where ...
This assumes that server#1 is listed in server#2's sqlhosts file, and
access levels (hosts.equiv, etc.) are set so that you have permission to
see the other server.
--EEM
> -----Original Message-----
> From: Guido Jimenez M. [mailto:pguidojm@yahoo.com]
> Sent: Wednesday, November 09, 2005 3:01 PM
> To: Grupo Informix
> Subject: Select from 2 Servers
>
> Fellows:
>
> I have this scenario:
>
> Sever#1 with database xx1
> Server#2 with database xx2
>
> I need to retrieve information from Server#1 database xx1 table abc
> What is the SELECT sintaxis I must use ? considering I use the
Server#2 as
> a production Server ?
>
> Thanks in advance .!
>
>
> ---------------------------------
> Yahoo! FareChase - Search multiple travel sites in one click.
> sending to informix-list
sending to informix-list