[AccessD] XML and DB2

Actually a lot of this is similar to the XML datatype added to SQL 
Server 2005 and the use of FLOWR in XPath
I haven't seen a comparision of methods between MS SQL and DB2, but both 
methods of storage are there.
It does make for some very easy construction of recursive SQL to do BOM 
type querys for parts explosions.

The Fundamentals of the SQL Server 2005 XML Datatype
http://www.developer.com/db/article.php/10920_3531196_1

Use with ado.net

http://www.developer.com/net/net/article.php/11087_3406251_1

XML Indexes in SQL Server 2005
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/forxml2k5.asp

What's New in FOR XML in Microsoft SQL Server 2005



Gustav Brock wrote:

>Hi all
>
>As to the recent threads on XML, here are some notes on how IBM adds
>XML support to the core of the DB2 query parser and extends SQL to
>directly handle, store, and index XML data without transformation:
>
>http://www.db2mag.com/story/showArticle.jhtml?articleID=167100937 
>
>This is still in beta but is planned for the next major release.
>
>/gustav
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada