Hi Wade,
I think what you are looking for is JDBNet (not to be confused with JDENet).
From KG Document ott-99-0076
<Snip>
JDBNET is the process by which OneWorld® makes database requests across enterprise servers in an organization with non-homogenous solution.
JDBNET eliminates the need for database-specific network software. JDBNET on the client defines and bundles the database request. JDENET then transports the request to the server where the data request is to be processed. JDBNET on the server un-bundles and processes the database request, creates a new bundle of the output from the database request. Then JDENET transports the new bundle back to the client. JDBNET on the client then un-bundles the output and processes the data. JDBNET and JDENET are specific OneWorld® operation protocols.
</Snip>
You would install OneWorld services on the NT/Oracle machine. The AS400 server map datasource would then be configured to point to the NT machine with a type of JDBNet instead of Oracle. When the AS400 needed data from that
I have not ever had a need to do this. I can't tell you if it works reliably or how the performance compares to a direct database connection.
If you give it a try, let us know how it works out.
Regards,
Justin Miller
[email protected]
working with B7332 and XE on AS/400, NT, Solaris and AIX