Re: XML-INTO & path

As the article I referenced would have told you, without count fields items will be considered "missing" if the array is not filled. So, for example, if Products is defined with Dim(99) then f the XML contained less than 99 elements then the others would be "missing". The addition of the count allows RPG to tell you how many there actually are and so they are not considered to be missing.

Using allowmissing=yes is REALY REALY dangerous. Fro example - the file could basically be "empty" and RPG would not signal an error. By using count fields with all arrays and with any optional items you can always be sure that it will error out if the file is bad.

P.S. Your current DS can probably lose the outer DS (gOutputDs) and just start with Products but you may need a path. If you load directly into Products array then the count for this level will be in the PSDS.

If you would like to email me your completed D specs I'll show you how to adjust them.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Aug 28, 2018, at 9:02 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

Just adding "allowmissing=yes" didn't help, the DS was still empty. I decided to pare things back and get at least something to work. I started pulling just the ID value from a single tag. I got that working and just expanded it. The final solution was to add another dimension to my DS. That worked and allowed me to load the whole thing with a single XML-INTO rather than five. Unfortunately, the single XML-INTO takes 50% longer than the five previously used (combined), and it now only works with "allowmissing=yes" (not sure why, since it's loading all the fields).

Working data structure:
Dcl-ds gOutputDs qualified inz ;
Dcl-ds Products ;
Products likeDs() dim() ;
End-ds ;
Dcl-ds Stages ;
Stages likeDs() dim() ;
End-ds ;
Dcl-ds productsToLoad ;
productsToLoad likeDs() dim() ;
End-ds ;
Dcl-ds loadedContainers ;
loadedContainers likeDs() dim() ;
End-ds ;
Dcl-ds unloadedProducts ;
unloadedProducts likeDs() dim();
End-ds ;
End-ds;

Thank you



-----Original Message-----
From: Jon Paris [mailto:jon.paris@xxxxxxxxxxxxxx]
Sent: Monday, August 27, 2018 12:56 PM
To: Rpg400 Rpg400-L <rpg400-l@xxxxxxxxxxxx>
Subject: Re: XML-INTO & path

OK - temporarily add allowmissing=yes to the options and see if that fixes it and you get data into the structures.

If it does then the real fix is to add the option countprefix=xxxxx ( xxxxx = your choice of name - I use count_ ) and then add the count fields to the DS. Like so:

count_Products int(5);
Products likeDs() dim() ;
count_Stages int(5);
Stages likeDs() dim() ;
etc.

See this article if you want to understand more about the option and why it is needed. https://www.itjungle.com/2015/08/18/fhg081815-story01/ <https://www.itjungle.com/2015/08/18/fhg081815-story01/>


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD