loading xml into db2 tables

[db2admin]

hello,

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

 

[Joseph Kesselman]

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.

 

[Joseph Kesselman]

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/

 

[Joseph Kesselman]

In ast versions

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

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