James Conrad StJohn Foreman wrote:
Thanks Brian, Serge.
select xmlagg(xmlelement(NAME a, email_address)) FROM
advertising.recipients;
Gives me
Function not supported (Reason code = "58"). SQLSTATE=42997
:-(
Running DB2 Express 8.2.1 on SLES 8. Do I need to be installing XML
extenders or something?
Wrap it into XML2CLOB(...)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab