Re: XML-SAX *XML_EXCEPTION event and reported parsed length question

Nathan

I had questions like this, too, and I'm satisfied that I can get what I want now.

You really should try it some, go online and see all the material on XMLTABLE - this is not exclusive to IBM i - it is functionality supported in all manner of RDBMS.

Basically you specify a level in the hierarchical structure as a starting point - kind of like a root directory, except you can name other nodes both above and below the root. You can use .. (double-dot) to refer to something above.

You specify the columns using references to nodes within the root, and above, if needed.

HTH
Vern

On 7/12/2017 5:33 PM, Nathan Andelin wrote:

I'd be shocked if XMLTABLE, which uses a SET based approach, doesn't
perform faster.

I haven't used XMLTABLE yet. But I'm a little perplexed about mapping
hierarchically structured "documents" to "tables". Vern indicated that he
would be populating about 13 tables from apparently one XML document.