SELECT XMLAgg( XMLElement("Extend", XMLElement("Name",extend_name), XMLElement("Value",extend_value) ) ), trxnmid FROM iby_trxn_extensibility GROUP BY trxnmid
View Text - HTML Formatted
SELECT XMLAGG( XMLELEMENT("EXTEND" , XMLELEMENT("NAME" , EXTEND_NAME) , XMLELEMENT("VALUE" , EXTEND_VALUE) ) ) , TRXNMID FROM IBY_TRXN_EXTENSIBILITY GROUP BY TRXNMID