XML challenge

Daniel Luksetich

XML challenge
Folks,
I have some XML in a string stored in a varchar field of 16,000 bytes
EBCDIC. I am interested in an SQL statement that will convert the string
into an XML data type such that various XML functions can then be applied
to the XML result. Anyone done this with success? I'm currently playing
with the XMLCAST and XMLSERIALIZE functions. I'm not getting the expected
results.

Thanks,
Dan Luksetich

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv