Re: Special Parsing Using XML-INTO

On Nov 4, 2015, at 11:11 AM, Vicki Wilson <VWilson@xxxxxxxxxxxxx> wrote:

We have exactly the situation that Alan describes - a payload inside the CDATA. What I'm doing is using XMLTABLE to extract it as XML and then it gets worked with.

If you need to pass a chunk of XML and don't want to pass the whole thing you might look at XMLTABLE.

And thanks to Alan. We don't do a lot of XML and we thought it was questionable XML to see XML inside of XML. I guess this is not such an uncommon although still not optimal occurrence.
http://www.soapui.org/functional-testing/working-with-cdata.html

Vicki Wilson
----------------------------------------------------------------------

message: 1
date: Tue, 3 Nov 2015 17:21:38 +0000
from: Moses Nang <moses.nang@xxxxxxxxxxxxxx>
subject: Special Parsing Using XML-INTO

Hello,

I apologize if someone has already asked this question. I have a task where I need to parse an XML document, but part of the xml needs to be saved to a variable and then passed along to another program that will actually parse that part of the xml. How can I do that using XML-INTO? So for example, in program GETCARRIER, I will parse the state element, but I also need to pass along to another program, the order_send node, which will parse that section.

<request>
<program>GETCARRIER</program>
<state>WI</state>
<order_send>
<billto>
<name>XYZ CORP</name>
<addr1>123 MAIN STREET</addr1>
<city>MADISON</city>
<state>WI</state>
<zipcode>53701</zipcode>
</billto>
<shipto>
<name>XYZ CORP</name>
<addr1>123 MAIN STREET</addr1>
<city>MADISON</city>
<state>WI</state>
<zipcode>53701</zipcode>
</shipto>
<itemlist>
<item>
<sku>67130</sku>
<qtyord>1</qtyord>
</item>
</itemlist>
</order_send></request>

Thanks,
Moses Nang
Integrated Merchandising Systems, LLC
847-583-7112


This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this email or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this email in error, please immediately notify us by calling the Help Desk at (847) 583-4111.
--
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: 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.