How to access across the instance

Posted in 2004

Vijay — Thu, 5 Feb 2004 17:49:36 +0530 — source: Usenet: comp.databases.informix

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

↪ replying to Vijay

Obnoxio The Clown — Thu, 05 Feb 2004 14:26:29 +0000 — source: Usenet: comp.databases.informix

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. > 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 -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

↪ replying to Vijay

June C. Hunt — Thu, 5 Feb 2004 09:52:59 -0500 — source: Usenet: comp.databases.informix

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