I'm looking for a function that allows you to manipulate data in a table and transform them into XML.

On DB2 i have used XMLELEMENT function but with this one i must know table columns.

From oracle i use sys.dbms_xmlgen.getxml from oracle.

There is a similar function in DB2 9.7 (i have Oracle compatibilty activated).

Thanks to all.