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





Vernon,

I think you will find the previously mentioned post on Mike Cain's blog,
and the white paper very helpful. The publishing functions (XMLELEMENT,
XMLATTRIBUTES, XMLDOCUMENT, etc) are what you want to use. Both of the
mentioned resources directly compare the publishing functions to the XML
Extender option.

I expect you will find the built-in SQL/XML support superior to the XML
Extender option. The XML Extender solution was a remarkable bit of
technology, but it has now fallen very far behind the W3C XML standards and
doesn't conform to the ISO SQL standard either. The SQL/XML approach
offers more functionality, and is a standardized part of the SQL language.
We have not done an all-inclusive performance test, but the scenarios I
looked at suggest SQL/XML performs better as well (My blog post on Mike
Cain's blog provides some details to back up this claim).

For these reasons, DB2 for z/OS and DB2 for LUW have already depreciated
the XML Extender solution in favor of SQL/XML

The other thing to keep in Mind is that the XML Extender is a priced option
and SQL/XML is included in DB2 for i 7.1.

I have not used CGIDEV2, but I suspect some of the same comments for the
XML Extender will apply to this tooling as well. SQL/XML is the preferred
approach when working with both XML and relational data in a query.

Nick Lawrence
DB2 for IBM i

Success is not final, failure is not fatal: it is the courage to continue
that counts.
- Winston Churchill

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.