×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Am 02.09.2024 um 18:34 schrieb Mihael Schmidt <mihael@xxxxxxxxxxxxxx>:
If it is clear that the amount of data (number of array elements) is unclear and obviously will differ much then having a fixed structure is not a good idea.
In your case why don't you use a SAX parser?
I thought long and hard, if I should answer - because my answers are nearly always "instead of this do this" and I fear, that at some point in time people might get tired of my 2 cents.
But as you - Mihael - opened up this path, here is my (strictly personal) opinion:
Especially when dealing with large amounts of data without a fixed/restricted number of elements in XML or JSON, my recommendation is SQL.
The XMLTABLE function does all the heavy lifting, and you can develop and test it interactively until the result table fits your needs.
->
https://www.ibm.com/docs/en/i/7.5?topic=functions-xmltable
You can even JOIN relational data or other XML data to your queries.
Yes - XMLTABLE looks daunting - for some even terrifying - but once you learned the basics, you can iteratively refine your query and test everything.
Maybe this might help
Kind regards,
Daniel
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
