I am trying to use code similar to that below to test the output of a call (using the “contains” phrase for a varchar output field). I receive an unexpected error. I am currently using version 1.6, but should soon upgrade to version 1.8. Is there anyway to check the XML generated as an output?
Thank you for your assistance!
XMLAttributes('Section Header ’ as “name”),
xmlelement(“header”,xmlagg(xmlcolattval(a.fld1 as “Fld1”,a.fld2 as “Fld2”))),
(XMLColattval(a.fld3 as “Fld3”, a.fld4 as “Fld4”))))
FROM tbltest a
WHERE a.pk = value;