[ajug-members] DB2 CLOB help

[Joe Sam Shirah]

    Hi Mike,

    Straightforward CLOBs just deal with characters and don't involve any
protocols like XML, so there shouldn't be any automatic conversions from
just the JDBC point of view.

    You might first check if any DB2 XML extensions are activated.

    Second, if any standard query tool shows the "stripped" data, then my
feeling is that the XML is being converted at ( or prior to ) storing,
rather than at retrieval.

    That's probably about all anyone can say without seeing the program
specifics.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Barnes, Mike" <mike.barnes at cingular.com>
To: <ajug-members at ajug.org>
Sent: Tuesday, June 06, 2006 9:19 PM
Subject: [ajug-members] DB2 CLOB help


I am having trouble retrieving xml data that has been stored in a CLOB
field on our DB2 database.



I am able to get the data but when I go to print it out all of the XML
tags have been stripped.



Could someone please point me to some example that retrieve XML data
from a CLOB







Thanks

Mike Barnes




----------------------------------------------------------------------------
----


> _______________________________________________
> ajug-members mailing list
> ajug-members at ajug.org
> http://www.ajug.org/mailman/listinfo/ajug-members
>