Front page | perl.dbi.users |
Postings from February 2001
Re: Hetrogenous joins
From:
Michael A. Chase
Date:
February 12, 2001 13:36
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