Re: Want to access AS400 DB2 database from Oracle stored procedures..

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Sun, 11 Nov 2001 03:12:24 GMT
Message-ID: <pan.2001.11.10.22.12.06.147.1413@earthlink.net>

In article <92a0e580.0111092121.35f2208f_at_posting.google.com>, "Manoj Nair" <debo_nair_at_yahoo.com> wrote:

> any help , hints or links would be appreciated...Thanks

There is an oracle product called "Transparent Gateway" which, I believe, can access DB2/AS400 but you can always write your own routines and map them as PL/SQL procedures. Read about the external procedures in the PL/SQL manual. You can write those in C and Java, but I prefer C for performance reasons. You don't need an interpreter to run a C program and you do need one to run or crawl Java.

-- 
Mladen Gogala
I love the smell of napalm in the morning. It smells like victory.
Apocalypse Now

Received on Sat Nov 10 2001 - 21:12:24 CST