Help on Db2 Xml Extender Using Xml Collection

[Avancha Mallikarjun]

HI
I am facing some Problems with Xml Extender which is used for Composing and decomposing of Xml documents through predefined stored procedures of Db2 Data base.. I was able to generate the XMl documents of Db2 using Xml Extender by using Xml Collection and using dxxGenXml() built in stored procedure.But this stored Procedure is Generating one XMl file for every row the Sql query returns and puts in a Temporary Table(which is passed to the Stored Procedure) of db2 which can be of XmlVarchar or Clob etc.
But is there any way where in i can get a single XMl File for all records of the SQl query