Re: Is there a way to load iSeries data directly into Oracle on another machine?

Dave,

Linoma has a product that will do this very nicely.

www.linoma.com

looking for...

Don in DC

--------------------------------------------------------------------

At 01:21 PM 10/19/2005 -0700, Dave Odom wrote:

I know I keep coming up with weird stuff but I'm in a weird environment;
well maybe not so weird.

In any event, there's this application being built in a Windoz
environment running Oracle. (Yes, I tried to convince them to talk to
DB2/400 vs Oracle since they need data from my iSeries anyway, but there
is a bigotry toward Oracle for any new application development).   This
application needs some of the data from my iSeries on a nightly basis.
What I'd love to do is kick off a scheduled job on the iSeries that
extracts data from the iSeries using a program(s) that I write that call
SQL stored procedures and then load directly into some Oracle tables in
the Windoz environment.    This is kinda like... is there an iSeries to
Oracle DRDA or some such.

Anyone ever done something like that?  If so, how?

Thanks to all of you for all your help,

Dave Odom
Arizona
--
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.