Re: Select from 2 Servers

My apologize, I forgot to say, Server#1 and Server#2 are in different machines. Obnoxio The Clown <obnoxio@serendipita.com> wrote: Guido Jimenez M. said: > > Well, > IBM Informix Dynamic Server Version 9.40.FC3. > According to your SELECT , where is specified the Server ? You don't refer to the server, you refer to the Informix instance. > Obnoxio The Clown wrote: > > 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 > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in one click. -- 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com sending to informix-list