×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Eileen Keck wrote:
Either we need an XML parser to put it
into a correct format for the i-series to handle or upload the whole csv
file since it is multi-record format and parse it out myself.
For XML parsing in RPG, you have quite a few no-cost options. If you
are using V5R4+, you can use the XML-INTO or XML-SAX RPG opcodes. I can
point you to some articles to get you started if you like.
Scott Klement has ported Expat, a widely-used open source XML parser, to
i5/OS. This is a good option if you aren't at V5R4, or if you are
already familiar with Expat.
I don't know exactly how much they cost, but there are at least two
commercial offerings which can help out here too. RPG-XML Suite from
Krengeltech and DB2 Extenders from IBM. The
As for reading CSV files from RPG, it's not that bad. Again, Scott
Klement has provided a tool which simplifies the use of the IFS APIs.
He also provides an e-book describing how to work with stream files
using his tool.
Personally, I'd prefer XML to CSV, and I've found both Expat and the
XML-* opcodes to be quite useful. If you can't find enough info on
these tools in the archives, I can provide some links.
Hope this helps,
Adam
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
