DB2 Scalar functions - XMLTEXT - www.cadcobol.com.br

XMLTEXT

The XMLTEXT function returns an XML value with a single XQuery text node having the input argument as the content.

The schema is SYSIBM.
The function name cannot be specified as a qualified name.

string-expression: An expression whose value has a character string type: CHAR, VARCHAR or CLOB.

The data type of the result is XML.
If the result of string-expression can be null, the result can be null; if the input value is null, the result is the null value.
If the result of string-expression is an empty string, the result value is an empty text node.

Examples

Create a simple XMLTEXT query.

   VALUES(
     XMLTEXT(
       'The stock symbol for Johnson&Johnson is JNJ.'
     )
   )

This query produces the following serialized result:

   1
   ---------------------------------------------------
   The stock symbol for Johnson&amp;Johnson is JNJ.

Note that the '&' sign is mapped to '&' when a text node is serialized.

Use XMLTEXT with XMLAGG to construct mixed content. Suppose that the content of table T is as follows:

   seqno  plaintext                                                                   emphtext
   ------ -------------------------------------------                                 -----------------------------
   1      This query shows how to construct                                           mixed content
   2       using XMLAGG and XMLTEXT. Without                                          XMLTEXT
   3      XMLAGG will not have text nodes to group with other nodes,  mixed content   therefore, cannot generate


   SELECT
XMLELEMENT(
     NAME "para", XMLAGG(
       XMLCONCAT(
         XMLTEXT(
           PLAINTEXT
         ),
         XMLELEMENT(
           NAME "emphasis", EMPHTEXT
         )
       )
       ORDER BY SEQNO
     ), '.'
   ) AS "result"
   FROM T

This query produces the following result:


   result
   -------------------------------------------------------------------------------
   <para>This query shows how to construct <emphasis>mixed content</emphasis>
   using XMLAGG and XMLTEXT. Without <emphasis>XMLTEXT</emphasis>
   , XMLAGG
   will not have text nodes to group with other nodes, therefore, cannot
   generate
   <emphasis>mixed content</emphasis>.</para>

Examples

Related reference