Front page | perl.dbi.users |
Postings from February 2001
RE: Hetrogenous joins
From:
Tim Harsch
Date:
February 12, 2001 13:59
Subject:
RE: Hetrogenous joins
Two things
1) Of course if it is really difficult to do in any other way then you can
use perl/DBI and compare two result sets in memory. Its fast but memory
limited and you have to spin your own code for it which isn't as fool proof
as a join.
2) FYI Oracle has "transparent gateways" which can help you access other
non-Oracle DBs. Never tried them so I can't attest to their effectiveness.
> -----Original Message-----
> From: Michael A. Chase [mailto:mchase@ix.netcom.com]
> Sent: Monday, February 12, 2001 10:24 AM
> To: Dan Hopkins; dbi-users@perl.org
> Subject: Re: Hetrogenous joins
>
>
> If you are considering working in different RDBMS at different times, you
> would probably be better off making the SELECT and INSERT/UPDATE separate
> SQL statements. Other databases may have similar features, but they are
> likely to have significantly different syntax.
> --
> Mac :})
> ** I normally forward private database questions to the DBI mail lists. **
> Give a hobbit a fish and he'll eat fish for a day.
> Give a hobbit a ring and he'll eat fish for an age.
> ----- Original Message -----
> From: "Dan Hopkins" <dan.hopkins@ukonline.net>
> To: "'Mitchell, Louise M'" <Louise.Mitchell@pnl.gov>; "Dan Hopkins"
> <dan.hopkins@ukonline.net>; <dbi-users@perl.org>
> Sent: Monday, February 12, 2001 1:17 PM
> Subject: RE: Hetrogenous joins
>
>
> > Thanks, I knew it would be simple :)
> >
> > <offtopic>
> > Are DB links exclusive to Oracle? I thinking along the lines of
> different
> > datasources (Oracle/MySQL/SQLServer)
> > </offtopic>
> > > -----Original Message-----
> > > From: Mitchell, Louise M [mailto:Louise.Mitchell@pnl.gov]
> > > Sent: 12 February 2001 16:39
> > > To: 'Dan Hopkins'; 'dbi-users@perl.org'
> > > Subject: RE: Hetrogenous joins
> > >
> > > In Oracle, use database links...
> > > -----Original Message-----
> > > From: Dan Hopkins [mailto:dan.hopkins@ukonline.net]
> > > Sent: Monday, February 12, 2001 8:30 AM
> > > To: 'dbi-users@perl.org'
> > > Subject: Hetrogenous joins
> > >
> > >
> > > This may have an extremely obvious answer :) .... but I can't
> > > see it. Is it
> > > possible to do hetrogenous joins from within DBI (and
> > > DBD::Oracle in my
> > > case) ?
> > >
> > > That is,performing joins/updates across multiple DB's
>
>
>