loading xml into db2 tables

[db2admin]

hello,

is there any quick way to load xml into DB2 UDB tables

[Joseph Kesselman]

Re: loading xml into db2 tables

db2admin wrote:

is there any quick way to load xml into DB2 UDB tables

In ast versions of DB2, IBM provided tools for "shredding" XML into DB2
tables.

But if you have DB2 9, it now has a native "pureXML" data representation
for XML, making DB2 both a world-class relational database *and* a
world-class XML database. See

http://www.ibm.com/software/data/db2/xml/

There will still be times when shredding makes sense... but you really
ought to look at this alternative; unless you're trying to feed old
table-based code pureXML is very likely to be a better answer.

--
Joe Kesselman / Beware the fury of a patient man. -- John Dryden

[Joseph Kesselman]

Re: loading xml into db2 tables

BTW, you may also be interested to know that a slightly limited of DB2 9
is available as no-charge code, and includes pureXML support:

http://www-306.ibm.com/software/data/db2/express/

--
Joe Kesselman / Beware the fury of a patient man. -- John Dryden

[Joseph Kesselman]

Re: loading xml into db2 tables

Joseph Kesselman wrote:

In ast versions

Whups. "past versions", in case that wasn't obvious.

(Be sure brain is engaged before putting fingers in gear...)

--
Joe Kesselman / Beware the fury of a patient man. -- John Dryden