tags:

views:

155

answers:

3

Can anyone recommend some good resources that highlight the differences between Oracle and the AS/400 database?

I am trying to help someone with a lot of AS/400 experience implement an Oracle installation, and they need some guidance.

A book or online resource would be ideal.

+2  A: 

Hey there!

I've done this a fair few times and the solutions out there really depend on the environment (enterprise / mission critical or development). The BEST way would be the Oracle AS/400 Gateway. Here are some important links in that area:

Allow AS/400 apps to access oracle with the Oracle Access Manager:
Installation Guide for the AS/400 Oracle Access Manager

Allow your Oracle apps to access AS/400 tables and be queried using Oracle:
Oracle Transparent Gateway for DB/2

^^^Those products are fairly expensive but super powerful.^^^

Alternately, here are some more academic approaches to the situation:

Here's a technical comparison of the two technologies... It's a little propagandaish*.
Technical comparisons of Oracle and DB/2

Here's a document written from the opposite point of view - Someone moving from Oracle to DB2. I still find it's useful information:
Leverage your Oracle 10g skills to learn DB2...

And another IBM link that has some really great information all around:
IBM Developer Network Search Results

Hope this helps!

*Yes, I know propagandaish is not a real word.

Bruce the Hoon
A: 

These links are not AS/400 specific, but generally a good place starting with Oracle:

http://tahiti.oracle.com
http://asktom.oracle.com

John Smithers
A: 

Simple Talk Publishing have just set up http://www.oracleoverflow.com/, which is a dedicated Stack Exchange site. You could try posting your questions there?

David Atkinson