RE: Joining Tables Across Databases

#1 (**permalink**) 04-19-2008, 08:16 PM

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

wner-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">da tabase@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

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

#2 (**permalink**) 04-19-2008, 08:16 PM

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">da tabase@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

wner-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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode