Re: Huge XML file processing from IFS (IBMi)

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I would expect the XML-INTO parser to handle CDATA just fine...

Are you sure that's where your problem lies?

20MB isn't that big...I've hit the 1GB* limit in XML-INTO for XML docs
before ;)

*1GB for the default UCS processing...change it to SBCS and double your
limit.

Charles

On Thu, Jul 27, 2023 at 2: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.