LISTAGG fails with sqlcode=-433

Question

How to overcome from length issue on ListAGG function.

Answer 1

Try the XMLAGG function instead:

select 
--length (
substr(xmlserialize(
xmlquery('$L/text()' passing XMLAGG(xmlelement(name "a", ','||colname)) as "L") as clob(2M)
), 2)
--)
from syscat.columns;