RE: XML-INTO sample

You could always use XML-SAX and parse the XML file into named value pairs and write to a database.

Then you can spin thru all the levels quite easily via an RPG program.

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: 4
date: Thu, 15 Sep 2011 10:35:45 -0400
from: "Mark Murphy/STAR BASE Consulting Inc."
<mmurphy@xxxxxxxxxxxxxxx>
subject: XML-INTO sample

I am working on a proof of concept for processing an unknown number of XML documents that include some header info and an unknown number of details. I have looked through Scott's article at http://systeminetwork.com/article/real-world-example-xml, and it looks like XML-INTO will fit the bill, but I have not seen a good way to handle an unknown number of detail formats. Would I do that with an array embedded within the data structure at the right depth? If that is the case, I will need to set a maximum expected number of details. How do I know if I have overflowed that array?

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx