RE: Select from 2 Servers
Try this, it will work.
select * from DATABASE1@SERVERNAME1:Table1 A ,DATABASE2@SERVERNAME2:Table2 B where A.Field1 = B.Field2
Regards,
Mohammad Marwan
Senior DBA and Unix administrator
Cairo, Egypt
Mobile:+2 0122449825
mmarwan@mscc.com.eg
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Guido Jimenez M.
Sent: Wednesday, November 09, 2005 11: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
Notice:
This e-mail (including attachments) is confidential and is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please contact Mediterranean Smart Cards Company :+202 333 1400
sending to informix-list