Re: Huge XML file processing from IFS (IBMi)

[Brad Stone <bvstone@xxxxxxxxx>]

Is this a one time processing thing, or something you'll be doing often
with new data?  If the latter, see if they have a JSON option instead.  XML
= yuck.

If the former, there are XML to JSON converters online you could use, then
use YAJL to process it.

On Thu, Jul 27, 2023 at 3:45 PM Prakash Shanmugam <pshanmug@xxxxxxxxx>
wrote:

> Hi All,
> Would like to get your thoughts on the below situation-
>
> Need to process a huge XML (around 20MB size currently with 25K rows and
> could grow) from IFS folder using ILE RPG.
>
>
> First trying with XML-INTO, but got below error, due to XML data containing
> CDATA.
>
>
> XML data element: <PriceListID><![CDATA[1]]></PriceListID>
> Data structure subfield declaration: PriceListID varchar(25);
>
> Error Message: The XML document does not match the RPG variable; reason
> code 5.
> Reason code 5. The XML document contains extra XML attributes or elements
> that do not match subfields.
>
> Kindly suggest how to parse <![CDATA[...]], to get the value.
>
>
> Understand another option is to use the SQL capabilities. Came to know that
> it also has some limits. Not sure what are the limitations and how to get
> around these? Any examples of using SQL to read XML from IFS?
>
> Thanks!
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.