RE: Joining Tables Across Databases

Posted in 2003

Topics: SQL Development & Query Writing, Networking & sqlhosts Configuration, Versions, Editions & End-of-Life

Murray Wood (IList) — Fri, 31 Oct 2003 14:18:01 +1300 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------=_NextPart_000_0079_01C39FB9.CB4A34B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit See the full table syntax in the SQL Syntax Guide select whatever from database@dbservername:tablename MW -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Wilkinson, Marcus Sent: Friday, 31 October 2003 11:57 a.m. To: 'Informix List' Subject: Joining Tables Across Databases Hi, I'm pretty new to Informix and struggling finding information on the following question. I want to join tables from different databases using IDS 7.3 with logging turned off. Currently I can only find a way to join the tables with the databases in logging mode. I'm in a data warehouse environment so don't really want to turn logging on. Any information on this would be greatly received. Are there any parameters that I could set to get around this. Regards Marcus ------=_NextPart_000_0079_01C39FB9.CB4A34B0 Content-Type: text/html; charset="iso-8859-1" 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=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR> <STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt = 72.0pt 90.0pt; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: purple; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: = "Times New Roman" } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: Arial } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=3DEN-GB vLink=3Dpurple link=3Dblue> <DIV id=3D0></DIV> <DIV> See the full table syntax in the SQL Syntax=20 Guide</DIV> <DIV> </DIV> <DIV>select=20 whatever from <A=20 href=3D"mailto:database@dbservername:tablename">database@dbservername:tab= lename</A>  <SPAN=20 class=3D271261301-31102003> </DIV> <DIV>MW  </DIV><LABEL = id=3DHbSession=20 SessionId=3D"4171051886"></LABEL> <DIV> </DIV> <BLOCKQUOTE dir=3Dltr=20 style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = solid; MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: = owner-informix-list@iiug.org=20 [mailto:owner-informix-list@iiug.org]On Behalf Of Wilkinson,=20 Marcus Sent: Friday, 31 October 2003 11:57 = a.m. To:=20 'Informix List' Subject: Joining Tables Across=20 Databases </DIV> <DIV class=3DSection1> <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi, <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I'm pretty new to = Informix and=20 struggling finding information on the following = question. <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I want to join tables = from=20 different databases using IDS 7.3 with logging turned = off.   =20 Currently I can only find a way to join the tables with the databases = in=20 logging mode.  I'm in a data warehouse environment so don't = really want=20 to turn logging on. <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any information on this = would be=20 greatly received.   Are there any parameters that I could = set to get=20 around this. <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Arial">Regards <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Marcus <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Arial"> </DIV></BLOCKQUOTE> </BODY></HTML> ------=_NextPart_000_0079_01C39FB9.CB4A34B0-- sending to informix-list

↪ replying to Murray Wood (IList)

Obnoxio The Clown — Fri, 31 Oct 2003 07:03:52 +0000 — source: Usenet: comp.databases.informix

Murray Wood (IList) wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_0079_01C39FB9.CB4A34B0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > See the full table syntax in the SQL Syntax Guide > > select whatever from database@dbservername:tablename> > ------=_NextPart_000_0079_01C39FB9.CB4A34B0 > Content-Type: text/html; > charset="iso-8859-1" > 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=3Diso-8859-1"> > > > <META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR> > <STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt = > 72.0pt 90.0pt; } > P.MsoNormal { > FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" > } > LI.MsoNormal { > FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" > } > DIV.MsoNormal { > FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" > } > A:link { > COLOR: blue; TEXT-DECORATION: underline > } > SPAN.MsoHyperlink { > COLOR: blue; TEXT-DECORATION: underline > } > A:visited { > COLOR: purple; TEXT-DECORATION: underline > } > SPAN.MsoHyperlinkFollowed { > COLOR: purple; TEXT-DECORATION: underline > } > P { > FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: = > "Times New Roman" > } > SPAN.EmailStyle17 { > COLOR: windowtext; FONT-FAMILY: Arial > } > DIV.Section1 { > page: Section1 > } > </STYLE> > </HEAD> > <BODY lang=3DEN-GB vLink=3Dpurple link=3Dblue> > <DIV id=3D0></DIV> > <DIV> > size=3D2> See the full table syntax in the SQL Syntax=20 > Guide</DIV> > <DIV> > size=3D2> </DIV> > <DIV> size=3D2>select=20 > whatever from <A=20 > href=3D"mailto:database@dbservername:tablename">database@dbservername:tab= > lename</A>  <SPAN=20 > class=3D271261301-31102003> size=3D2> </DIV> > <DIV> > size=3D2>MW  </DIV><LABEL = > id=3DHbSession=20 > SessionId=3D"4171051886"></LABEL> > <DIV> </DIV> > <BLOCKQUOTE dir=3Dltr=20 > style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = > solid; MARGIN-RIGHT: 0px"> > <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft> face=3DTahoma=20 > size=3D2>-----Original Message----- From: = > owner-informix-list@iiug.org=20 > [mailto:owner-informix-list@iiug.org]On Behalf Of Wilkinson,=20 > Marcus Sent: Friday, 31 October 2003 11:57 = > a.m. To:=20 > 'Informix List' Subject: Joining Tables Across=20 > Databases </DIV> > <DIV class=3DSection1> > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi, > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I'm pretty new to = > Informix and=20 > struggling finding information on the following = > question. > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I want to join tables = > from=20 > different databases using IDS 7.3 with logging turned = > off.   =20 > Currently I can only find a way to join the tables with the databases = > in=20 > logging mode.  I'm in a data warehouse environment so don't = > really want=20 > to turn logging on. > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any information on this = > would be=20 > greatly received.   Are there any parameters that I could = > set to get=20 > around this. > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = > Arial">Regards > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">  > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Marcus > <SPAN=20 > style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = > Arial"> </DIV></BLOCKQUOTE> > </BODY></HTML> > > ------=_NextPart_000_0079_01C39FB9.CB4A34B0-- > > sending to informix-list Nice one. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"

Related threads

Glossary

IDS (Informix Dynamic Server)