RE: [WEB400] Re: ASNA VRPG for .net or Websmart or RPGsp or somethingelse?

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx 
> [mailto:web400-bounces@xxxxxxxxxxxx]On
> Behalf Of dsager@xxxxxxxxxxxxxxxxx
> Sent: Monday, June 06, 2005 2:23 PM
> To: web400@xxxxxxxxxxxx
> Subject: [WEB400] Re: ASNA VRPG for .net or Websmart or RPGsp or
> somethingelse?
> 
<snip>
> 
> 
> 
> Regarding the transfer of information to an Oracle database, 
> hopefully you
> are aware that DB2/400 can interact directly with Oracle (at least per
> IBM's announcement).  So the question becomes do you need to 
> capture the
> presentation or the information it contains for transfer to the Oracle
> database?
> 
<snip>

What announcement are you referring to?

I know of no way for DB2/400 to interact "directly" with Oracle unless one 
ponies up the big $$$ to purchase some extra software from either Oracle or IBM.

An iSeries Java application can use Oracle's JDBC driver, but I wouldn't call 
that DB2 acting "directly".  On the other hand, Oracle can use IBM's ODBC or 
OLEDB driver to directly access iSeries Tables.

Note that my definition of "directly" is a single SQL statement can join tables 
on separate systems.

Thanks,
Charles