It's all about the answers!

Ask a question

XML contents columns


Nicolas Dangeville (31632525) | asked Feb 06 '07, 1:13 p.m.
JAZZ DEVELOPER
DB2 v9 provides a XML data type to store XML contents in the column of a
table. Would it make sense to store the XML contents in XML columns rather
than CLOB columns in DB2 v9?

I have seen that today for db2, CLOB colunms are used for storing XML or for
storing text. Is there a way to distinguish when the mapping is done the
text contents from the XML contents?

Many Thanks,

Nicolas

One answer



permanent link
Scott Rich (57136) | answered Feb 07 '07, 2:09 p.m.
JAZZ DEVELOPER
Nicolas Dangeville wrote:
DB2 v9 provides a XML data type to store XML contents in the column of a
table. Would it make sense to store the XML contents in XML columns rather
than CLOB columns in DB2 v9?

I have seen that today for db2, CLOB colunms are used for storing XML or for
storing text. Is there a way to distinguish when the mapping is done the
text contents from the XML contents?

Many Thanks,

Nicolas



It's a great idea, and I've just opened a work item to investigate the
latest XML support in DB2 V9. See
http://jazz.net/jazz/service/%7Bdefault%7D/WorkItem/17035

Scott

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.