Hello,
I'm writing some java code that reads data from a DB2 table on an IBM
iSeries which is then used to update a Clipper database on a Windows
server.
We have been instructed that the majority of the code needs to run on the
iSeries where the DB2 database exists and as little as possible on the
Windows server.
The ODBC driver that is supplied with Windows has the capability to access
the .DBF files used by Clipper so I am planning to use that to read/write
the Clipper database.
If my java class is running on the iSeries server then what's the best way
of accessing the ODBC driver on the remote Windows server?
I have considered using sockets to pass the data between two java classes
and also looked at RMI.
Any comments on using these approaches?
Is there another way of doing this?
Thanks

Signature
Glenn
Richard Schoen - 12 Jun 2004 14:57 GMT
Hello Glenn,
If you're open to a commercial option, you could use a tool such as our
RPG2SQL Integrator to write an RPG program that can read/write to your
Clipper tables via ODBC, assuming you can write to Clipper with ODBC.
The only components required on the Windows side would be our RPG2SQL
Integrator PC component and an ODBC driver for the Clipper tables.
If you're interested in discussing this in more detail or would like a FREE
demo of the product, please contact me directly.
Regards,
Richard Schoen
RJS Software Systems Inc.
"The AS/400 and iSeries Report and Data Delivery Experts"
Email: richard@rjssoftware.com
Web Site: http://www.rjssoftware.com
> Hello,
>
[quoted text clipped - 24 lines]
>
> Glenn
Franz-Josef Hoennekes - 15 Jun 2004 13:49 GMT
Glenn,
have look at the Advantage Database Server, that can also handle
Clipper .dbf data. It comes with a class 4 jdbc driver, that you can
use from the iSeries machine.
see www.advantagedatabase.com
HTH,
Franz-Josef.
> Hello,
>
[quoted text clipped - 21 lines]
>
> Thanks
Earl Tenolia Rice - 21 Jun 2004 09:20 GMT
I had to do the same thing using VB. All you have to do is use SQL from
clipper to open the record set. Good Luck
> Hello,
>
[quoted text clipped - 21 lines]
>
> Thanks