ISG-NAVIGATOR (an heterogeneous middleware) enables you just
that.
Please look a www.isgsoft.com , there's a live demo
Y.
Phillip H <hzl_at_optusnet.com.au> wrote in message
news:7m7p3l$noo$1_at_news1.mpx.com.au...
> Hi All,
>
> I am doing a thesis that query against at least two databases. These
> databases are heterogeneous. It may include Oracle, Microsoft Access,
> Microsoft SQL and DB2. A single query will involve at least two tables
that
> can be in same or different databases.
>
> For example, Payroll data is stored in an Oracle DB, while staff task data
> is in an Access DB. Now I want to retrieve all staff's current salary and
> current task list by a single SELECT statement (syntax may vary):
>
> SELECT name, salary, task
> FROM current_salary cs, current_tasks ct
> WHERE cs.name = ct.name;
>
> The purpose is to hide the details of data distribution. I implement it
with
> Developer 2000. Any ideas on how to do it are appropriated. Are there any
> books or web sites helpful?
>
> Thanks in advanced.
>
> Phillip
>
>
Received on Sun Jul 11 1999 - 03:45:03 CDT
