Re: How can I move data directly from DB2/400 table to

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

David, Elvis and Vern,
 
 
David,   I have no problem with java and two JDBC connections.   Have any examples?  If so, will you share and what platform would it run on; i5 or ???
 
Elvis,
 
Totally understand what you say about PULL vs. PUSH.  If I have to, I'll tell the programmer to code a PULL program on ORACLE... I'd just like to control when they do it via the i5.
 
As a quick and dirty solution...might try pulling from DB2 using SQL, create a temporary table or MQT and then do an FTP if I have to.
 
Looked at the WebSphere Integrator Product... Looks like a good solution but need to know more and worry about expense.  
 
Vern,
 
What are functions and features of RPG2SQL; the technical stuff not the marketing?  
 
As to REXX calling procedures in service programs...not sure... Can CL do it?  If so, REXX can.
 
Or if needs be I can create a C program that calls REXX to use the strengths of each language tool.
 
Thanks much,
 
Dave