DB2 on many platforms including iSeries allows tables with columns with the XML data type - the column holds XML data that can be referenced in SQL using XMLTABLE to directly reference specific XML tags.
The Wikipedia page on pureXML says that for DB2 on Windows, Unix, Linux, and z/OS the XML data is stored parsed, so that search/lookup is fast and efficient.
This old ITJungle article says that for iSeries, XMLTABLE has to dynamically parse the XML document each time: https://www.itjungle.com/2012/06/13/fhg061312-story02/
I can't find anything else that says one way or the other if the efficient XML processing on other platforms was ever brought to DB2 for iSeries.
Does anyone know one way or the other, if XMLTABLE on iSeries used the efficient pureXML process like z/OS, or if it still has to parse each time?
The Wikipedia page on pureXML says that for DB2 on Windows, Unix, Linux, and z/OS the XML data is stored parsed, so that search/lookup is fast and efficient.
This old ITJungle article says that for iSeries, XMLTABLE has to dynamically parse the XML document each time: https://www.itjungle.com/2012/06/13/fhg061312-story02/
I can't find anything else that says one way or the other if the efficient XML processing on other platforms was ever brought to DB2 for iSeries.
Does anyone know one way or the other, if XMLTABLE on iSeries used the efficient pureXML process like z/OS, or if it still has to parse each time?
Comment