2
Answers

DB2 to SQL conversion

nitin singh

nitin singh

6y
1k
1

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)