Joining Tables Across Databases

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

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C39F39.29D7D9F0
Content-Type: text/plain

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_001_01C39F39.29D7D9F0
Content-Type: text/html

<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">

<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color

urple;
text-decoration:underline;}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

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

 

</div>

</body>

</html>

------_=_NextPart_001_01C39F39.29D7D9F0--
sending to informix-list

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

"Wilkinson, Marcus" <mwilkinson@doubleclick.net> wrote
> 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.

You can join tables across databases as long as all databases are either
logged or not-logged. That is, a combination of logged database and non-logged
database can not be joined in a query.

rk-

--

email id is bogus

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