Re: Select from 2 Servers

Guido Jimenez M. said: > > 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 ? What version of Informix are you running? In general, if you want something from server1 and you're on server2, SELECT * FROM xx1@instanceXX1:abc I can't test that to make sure, but it is in the manuals. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com sending to informix-list