How to access across the instance

Vijay

unread,

Feb 5, 2004, 7:19:36 AM2/5/04

to

This is a multi-part message in MIME format.

------=_NextPart_000_00C6_01C3EC10.6B964D30
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi All,

I have 2 instances of informix databases on 2 different
machines. I need to select from 1 machine's table & update it to another
machine's table... Please let me know how to go about this? Thanks in
advance...

Regards,
Vijay Kumar.R

------=_NextPart_000_00C6_01C3EC10.6B964D30
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE id=3DridTitle>Message</TITLE>

<STYLE>BODY {
MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 25px; COLOR: #000000; =
FONT-FAMILY: Arial, Helvetica; BACKGROUND-COLOR: #ffffff
}
P.msoNormal {
MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; =
FONT-FAMILY: Helvetica, "Times New Roman"
}
LI.msoNormal {
MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; =
FONT-FAMILY: Helvetica, "Times New Roman"
}
</STYLE>

<META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR></HEAD>
<BODY id=3DridBody style=3D"BACKGROUND-COLOR: #ffffff" bgColor=3D#ffffff =

background=3D"">
<DIV><SPAN class=3D500431712-05022004>Hi All,</SPAN></DIV>
<DIV><SPAN class=3D500431712-05022004></SPAN> </DIV>
<DIV><SPAN =
class=3D500431712-05022004>        I=20
have 2 instances of informix databases on 2 different machines. I need =
to select=20
from 1 machine's table & update it to another machine's =
table...=20
Please let me know how to go about this? Thanks in =
advance...</SPAN></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Regards,</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Vijay=20
Kumar.R</FONT></DIV></BODY></HTML>

------=_NextPart_000_00C6_01C3EC10.6B964D30--

sending to informix-list

Vijay

unread,

Feb 5, 2004, 7:19:36 AM2/5/04

to

------=_NextPart_000_00C6_01C3EC10.6B964D30--

sending to informix-list
sending to informix-list

Obnoxio The Clown

unread,

Feb 5, 2004, 9:26:29 AM2/5/04

to

Vijay wrote:

> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_00C6_01C3EC10.6B964D30
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hi All,
>
> I have 2 instances of informix databases on 2 different
> machines. I need to select from 1 machine's table & update it to another
> machine's table... Please let me know how to go about this? Thanks in
> advance...

Kerrrrrrist! 65 lines for a 4 line question, *and* you post it twice. :o(

UPDATE database1@instance1:table1 SET column = SELECT column FROM
database2@instance2:table2 WHERE yadda yadda yadda. It is in TFM.

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

June C. Hunt

unread,

Feb 5, 2004, 9:52:59 AM2/5/04

to

Vijay wrote:
> Hi All,
>
> I have 2 instances of informix databases on 2 different
> machines. I need to select from 1 machine's table & update it to another
> machine's table... Please let me know how to go about this? Thanks in
> advance...

You can reference a table in a remote DB with the following syntax:

[database_name][@server_name][:]["owner".]tablename

For example:

INSERT INTO testtbl
SELECT * FROM cinfo@ids_p650:testit;

HTH
--
June Hunt