Re: Oracle 7.1 + AS/400

Kaj Bredenberg wrote:
>
> We are running Oracle 7.1 Work Group Server under Win NT. We are also
> using an IBM AS/400. My question is if anyone would have exeprience in
> using Oracle with AS/400 data bases ?
> I'd like to develop applications that would use Oracle database on NT
> server and AS/400 databases simultaneously.
> What tools are needed for that kind of purpose ?
>
> Kaj Bredenberg

Oracle's Open Gateway technology provides you with several solutions: you can go with a Transparent Gateway for DB2/400. There was a Transparent Gateway for SQL/400, but don't know if it is any longer about. (The March Production report from Oracle shows a FIX for it.) You can also develop your own using the Open Gateway Toolkit. Finally, the Transparent Gateway for EDA/SQL, if you have a mainframe somewhere in the mix, offers the greatest number of supported technologies through IBI's EDA/SQL capabilities.

Of course, if when you say "use Oracle database on NT server and AS/400 databases simultaneously" you don't necessarily mean a distributed database with data on both the NT and the AS/400 transparently operating as one, then you can "roll your own" solutions 3GL technology and the appropriate APIs (for example, OCI or Pro*Whatever for Oracle).

-- 
Hugo Toledo, Jr.   Author of "Oracle Networking" from Oracle Press
312.951.8012               Oracle WebSystem - Oracle Mobile Agents
mailto:hugo_at_mcs.com      Oracle Power Objects - Windows - Unix - C
http://www.mcs.com/~hugo/oracle.html        CompuServe: 72700,1705