DB2 to SQL conversion

Mar 15 2018 9:08 AM

I need to convert below DB2 query to SQL.

SUBSTR(xmlserialize(xmlagg(xmltext(CONCAT( ', ',DEL.COVERAGE_CODE))) as VARCHAR(1024)), 3) as COVERAGE_CODE

I am not able to get equivalents of xml related things in SQL. Any help would be appreciated

Answers (2)