× 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.



Hi Dave,

the DB2 XML functionality looks more complicated as it is. Some time ago, I've written a piece for my blog, where I generated XML from SQL.

-> https://qpgmr.de/create-xml-with-sql

I tried to have different XML structures in the example - it it's a bit "over engineered" - but there is XMLELEMENT, XMLAGG, XMLATTRIBUTES, XMLDOCUMENT and XMLSERIALIZE - everything you need to build a XML document.

HTH
Daniel


Am 04.06.2024 um 16:52 schrieb Dave <dfx1@xxxxxxxxxxxxxx>:

Hi,

Got given a bunch of PFs and told to generate an XML document from them.
Discovered the DB2 function XMLGROUP but it doesn't look easy to use for a
complicated document. Don't we have a "standard way" of doing this yet?

Tia

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.