Re: uploading dbase files using iSeries Access for windows

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

<verndor response>

Our RPG2SQL Integrator can read dBase files directly from an RPG program 
- uses the M$ desktop ODBC driver for dBASE and Foxpro - basically it's 
a read-only in my experience - more complex requires a for-cost driver 
from another vendor.

If interested, you can call us at 888.rjs.soft toll-free or ask for me 
or richard or sales or email us.
</verndor response>

On 11/3/2011 2:04 PM, Richard Schoen wrote:
> Could write a VB or VB.Net app to do the data uploads and write to the databases directly using the CA/400 database drivers.
>
> Read Dbase ->  Write DB2.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
>
> ------------------------------
>
> message: 7
> date: Thu, 3 Nov 2011 17:42:03 +0000
> from: "Harman, Roger"<Roger.Harman@xxxxxxxxxx>
> subject: RE: uploading dbase files using iSeries Access for windows
>
> I deal with dBase files all the time.  We just convert them to what dBase called SDF.  Flat, fixed length ASCII.
>
> We use a generic utility program I wrote eons ago that does a dBase "use [somefile]" and "copy to [somefile].txt type sdf" and "quit".  Easy to put in a PC job stream.