First attempts to use XMLELEMENT function not going well. Getting either errors or no results through QMF 8.1 and SPUFI. Some variations returned what appeared to be just the length of each CLOB row. Tried SUBSTR and SUBSTRING and CASTs, with no luck either. Source tables are just catalog tables (e.g., SYSIBM.SYSTABLES), not XML data.

Simple example:
SELECT XML2CLOB(XMLELEMENT( NAME "Test", 'Test'))
FROM SYSIBM.SYSDUMMY1
WITH UR

Returns this in my QMF:
COL1
----------------
CLOB(2147483647)

Should this work in V8, or do I need to wait until we upgrade to V9?

Thanks...

Found help in another thread. Adding VARCHAR() function around XML2CLOB made it work!