Re: Access to AS/400 data

From: Gary Schmidt (Gary.Schmidt_at_oz.quest.com)
Date: 08/29/03 

Date: Fri, 29 Aug 2003 13:21:19 +1000

Nicholas Dronen wrote:
> VinceM <vincem@nospam.com> wrote:
> V> "VinceM" <vincem@nospam.com> wrote in message
> V> news:1061937555.897558@nnrp2.phx1.gblx.net...
>
>>>Does anyone know of any techniques/products which would allow access to
>>>AS/400 database files from AIX?
>>>
>>>
>>
> V> Specifically what I would like to do is an SQL join between an Oracle table
> V> on AIX and a DB2 table on an AS/400.
>
> This has very little to do with AIX. You should be looking at an
> ODBC-based gateway that you can access from with Oracle. If you
> don't want to shell out the money, you'll have to roll your own
> method using perhaps a shell script that calls a command-line client.
>
> Regards,
>
> Nicholas
>

Nicholas, why do you insist it must be done using ODBC? Accessing a DB2
database on _any_ machine from AIX is simply a matter of connecting to
it, which the DB2 CLI API does very well.

That said, as the OP wants a join between two totally disparate
tables/machines/databases they may have to look at some sort of
middleware product that does the join itself.

I did something similar many years ago using a product from the company
now known as http://www.datadirect-technologies.com back when they were
known as Intersolv.

        Cheers,
                Gary B-)