Re: Exchanging data between two instances
Rob,
This should work however I believe that it is
insert into ourtable
select * from yourdb@yourserver:ourtable;
If this doesn't work let me know what the errors are.
David Link
----- Original Message -----
From: Rob Gale <rgale@[no_spam]iclretail.com>
To: <informix-list@iiug.org>
Sent: Tuesday, July 27, 1999 8:11 PM
Subject: Exchanging data between two instances
> Please forgive my naivete, but is it at all possible to do something like:
>
> connect to mydb@myserver;
> select * from yourdb@youserver:ourtable
> insert into ourtable;>
> It seems that this would be a logical thing to want to do. Obviously I
have
> tried this and failed, but is that because my approach is wrong ? What
about
> exchange between different instance versions, e.g. 7 and 8
>
> Regards,
> Rob Gale
>
>
>