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.
SELECT XML2CLOB(XMLELEMENT( NAME "Test", 'Test'))
Returns this in my QMF:
Should this work in V8, or do I need to wait until we upgrade to V9?