|
Dave, There are three options: 1) Using JBDC in a Java app on the iSeries to read/write directly to Oracle. iSeries Network had a recent article about doing this with SQL server, it was no big deal to modify it to goto Oracle also/instead. RPG apps wrote requests to a DTAQ, a never ending Java program would pick up the request, send it to the external DB and load the result back to another DTAQ. 2) Oracle's Access Manager for AS-400. This is an OS/400 software application that translates OS/400 DRDA requests into Oracle's network protocol. You use SQL on the 400 as if it was any other remote DRDA (aka DB2 UDB) database. 3) Third party middleware. Such as RJS's product or IBM's. These products sit on a PC (usually) and translate request from the 400 into ODBC, OLEDB, or even proprietary protocol requests to Oracle. Note that #2 is packaged with the Oracle Transparent Gateway for DB2/400 and Oracle Transparent Gateway for DRDA products which allow the Oracle database to access DB2/400 as if it was another Oracle DB. But the base(?) list cost is $35K. The TG for DB2/400 is actually an AS/400 application as is the Access Manager for AS-400 product. The TG for DRDA sits on a PC and will access any DRDA DB. HTH, Charles Wilt iSeries Systems Administrator / Developer Mitsubishi Electric Automotive America ph: 513-573-4343 fax: 513-398-1121 > -----Original Message----- > From: midrange-l-bounces@xxxxxxxxxxxx > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dave Murvin > Sent: Sunday, February 13, 2005 10:10 PM > To: midrange-l@xxxxxxxxxxxx > Subject: How can I read Oracle 9i table on Win2003 server from AS/400? > > > I would like to be able to read an Oracle 9i table that is on > a Windows > 2003 server from an AS/400 application. We currently > exchange files though > the IFS, but this is a nightly batch job. I would like to > read the table > on demand, hopefully without having to buy any more software. I have > looked at the archives and the info center for ODBC, but didn't see > anything that seemed to fit. Most of the articles I saw were about > connecting a PC to the AS/400 via ODBC, and the code examples > were for > Visual Basic or in C. I would be coding the program in > ILERPG or CL. I > know there is a Oracle Access Manager out there, but it seems > unlikely that > this is a free product. > > Any suggestions or ideas? Additional places to search? > Manuals to read (I > have looked and not seen anything so far)? > > Thanks > > Dave Murvin > DRM Enterprises, Inc. > > > -- > This is the Midrange Systems Technical Discussion > (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.