Re: Select from 2 Servers


Guido Jimenez M. said:
>
> My apologize,
>
> I forgot to say, Server#1 and Server#2 are in different machines.

It doesn't matter -- you refer to the instance, not the machine. You have
to define both instances in both SQLHOSTS files.

> Obnoxio The Clown <obnoxio@xxxxxxxxxxxxxxx> 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
>


--
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
.

Relevant Pages

  • Re: Use of comp.databases.informix
    ... > likely to get passions rising in this group than comparing Oracle and ... > when you really want to talk about Informix. ... columns in a table except the primary key could/should be nullable. ... and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
  • Re: Could not determine which columns uniquely identify the rows for [Table Name]
    ... Going back over the 3 databases I was using as tests, I found that the SQL ... Server DB table that was created did hold the primary key that I set. ... But, I need or would like to get it working for Informix, because they would ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Shocked! Shocked, I tell you!
    ... >> So, I wonder who this nebbish is, and whether he's counting down the 206 ... >> days till IBM discontinues support for Informix as an independent ... columns in a table except the primary key could/should be nullable. ... and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
  • Re: Wire Diagrams
    ... > I am looking for a source of wire diagrams that would show all of ... > versionof Informix. ... columns in a table except the primary key could/should be nullable. ... and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
  • Re: Select from 2 Servers
    ... Obnoxio The Clown wrote: ... where is specified the Server? ... You don't refer to the server, you refer to the Informix instance. ... > and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)