Re: current state of xml-into v6r1

James,

With a file that big, assuming you need all or most of the information, the problem might be that the information won't fit. The data structure that receives the information cannot be larger dan 16 gig. Alternatively you might use XML-INTO with a handler (although I have to admit that glancing at the docs I don't quite understand how that is done) or use XML-SAX and handle all information consecutively.

Joep Beckeringh


Op 27-07-12 19:38, James Franz schreef:

Do not have file yet, but rough estimate is 10 to 20 gig.
--- On Fri, 7/27/12, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:


From: Henrik Rützou <hr@xxxxxxxxxxxx>
Subject: Re: current state of xml-into v6r1
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Date: Friday, July 27, 2012, 5:15 PM


How big is the file?

On Fri, Jul 27, 2012 at 7:11 PM, James Franz <jfranz46@xxxxxxx> wrote:

I am reviewing options for a project where will receive an export file
from a non-i system, in xml, ftp'd to us, with a dozen tables in the single
xml (order header,vendor, customer, order detail, etc, ... next order
header...) where there will be perhaps half million orders. We have specs
only, no file yet. The dtd seems straight forward, plus a separate excel of
each column definition.
Before we head down the xml-into route, is there any limits for processing
a file of millions of records? No single column will exceed perhaps 1000
bytes.
We have no xml tools (and no budget for this import).
We do have the recent v6r1 namespace ptfs.
Also looking at Scott's Expat example.
tia
jim franz

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.