Re: ODBC from IFS

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Don

Here is an article that covers this topic. Might be helpful:

<http://www-919.ibm.com/developer/db2/documents/data_acc/index.html>

called "Heterogeneous data access for iSeries applications". Covers the 
Java approach, and others.

This came from the iSeries DB2 page - tips - 
<http://www-1.ibm.com/servers/eserver/iseries/db2/db2tips.htm>

Vern

At 11:51 AM 7/9/2003 -0700, you wrote:
> My particular problem was wanting to access files
> residing on Windows PC's using Java (or even RPG)
> applications that reside on the iSeries.
> ODBC can be used for other databases, i.e. dbase
> III/IV, MS Access, etc.
>
> These databases exist because different departments at
> our organization has aquired applications (for one
> reason or another) that run on PC's and utilize these
> databases.  I would like be able to run applications
> strictly off of our Enterprise System (iSeries) to
> access & manipulate these heterogeneous databases.
>
> I currently have been writing Java programs that
> reside on the PC's and I will kick them off from our
> iSeries (i.e. runrmtcmd, or PC Scheduled jobs, etc).
>
> Not being able to do this from the iSeries is killing
> my argument with management to expand our iSeries' &
> NOT our server farm.  But when we are able to access
> any application's (including iSeries) database from an
> application residing on a PC, and not from an iSeries,
> then my argument becomes moot.
>
> I have discussed this with people at IBM & others.
> Joe Pluta at one time turned me onto the SQL 2000 JDBC
> type IV driver, which helps with the SQL 2000 access,
> but not the others.
>
> Don