Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help on Db2 Xml Extender Using Xml Collection

 
Avancha Mallikarjun
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic