Re: Access to AS/400 data
From: Nicholas Dronen (ndronen_at_io.frii.com)
Date: 08/29/03
- Previous message: Hans-Joachim Ehlers: "Re: disk space used in AIX 5.1L"
- In reply to: Gary Schmidt: "Re: Access to AS/400 data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 29 Aug 2003 15:50:05 GMT
Gary Schmidt <Gary.Schmidt@oz.quest.com> wrote:
GS> 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.
GS> Nicholas, why do you insist it must be done using ODBC? Accessing a DB2
GS> database on _any_ machine from AIX is simply a matter of connecting to
GS> it, which the DB2 CLI API does very well.
I don't *insist* he must use ODBC. Since he wants to do a JOIN with
SQL, he's going to have to use a gateway *or* a protocol translator
built into his RDMBS. I believe, with Oracle, you can plug ODBC
drivers into the RDMBS, and voila!, you have connectivity to another
RDMBS. That's probably a hell of a lot cheaper than buying a
gateway. That's why I mentioned ODBC. He's using Oracle already.
I might be wrong about Oracle's support for this, but if not, buy
an ODBC driver, close case.
GS> That said, as the OP wants a join between two totally disparate
GS> tables/machines/databases they may have to look at some sort of
GS> middleware product that does the join itself.
>
GS> I did something similar many years ago using a product from the company
GS> now known as http://www.datadirect-technologies.com back when they were
GS> known as Intersolv.
Between Intersolv and DataDirect, they were Merant until Merant
spun them off. I was a developer for a RDBMS gateway that translated
TDS to DB2 (OS/360 and OS/400, using their native protocols, and
using either TCP/IP and SNA, except OS/400, which was just SNA),
and used Merant/DataDirect ODBC drivers to talk to Informix, and
DB2 on OS/400 over TCP/IP. That's for TDS. This guy wants to be
able to translate OCI or whatever Oracle calls its wire protocol.
Regards,
Nicholas
-- "Why shouldn't I top-post?" http://www.aglami.com/tpfaq.html "Meanings are another story." http://www.ifas.org/wa/glossolalia.html
- Previous message: Hans-Joachim Ehlers: "Re: disk space used in AIX 5.1L"
- In reply to: Gary Schmidt: "Re: Access to AS/400 data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
