Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: DB2/zOS V8 XML2CLOB SPUFI or QMF?

    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...

  2. #2
    Join Date
    Sep 2009
    Posts
    2
    Found help in another thread. Adding VARCHAR() function around XML2CLOB made it work!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •