On Tue, 5 Feb 2013 at 8:12am, "D*B" <dieter.bender@xxxxxxxxxxxx> wrote:
... there are JDBC drivers for CSV files (I never tried one of those...) and ArdGate...
one of the problems, I didn't understand in your description, you get column names, but where to get type information?
The approach I've been taking is to develop an Open Access handler to read CSVs. The published version doesn't handle using column headings to associate the fields with the data - that is the next instalment - but OA deals with providing the field characteristics.
Article is here
http://www.ibmsystemsmag.com/ibmi/developer/rpg/input_handlers/ and includes a link to the source files.
Jon Paris
www.partner400.com
www.SystemiDeveloper.com
