ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How do I add CDATA sections to XML with the SQL xml functions?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I add CDATA sections to XML with the SQL xml functions?

    I have to build XML which contains a chunk like this:
    Code:
          <abcd:ABLK>
             <abcd:innerBlock><![CDATA[<ABCDRequest>codename1,codename35</ABCDRequest>]]></abcd:innerBlock>
          </abcd:ABLK>
    xmlelement() and xmlforest() will html encode a string, so '<' becomes :lt; - I don't see any way of building the above except by doing it manually with string manipulation.


Working...
X