This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes XML and Related Technologies and the fly likes Help on Db2 Xml Extender Using Xml Collection Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Reply Bookmark "Help on Db2 Xml Extender Using Xml Collection" Watch "Help on Db2 Xml Extender Using Xml Collection" New topic
Author

Help on Db2 Xml Extender Using Xml Collection

Avancha Mallikarjun
Greenhorn

Joined: Sep 28, 2001
Posts: 4
posted
0
Quote
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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Help on Db2 Xml Extender Using Xml Collection
 
Similar Threads
Reading BLOB data in DB2 SQL Stored Procedure
XML as inbound data?
DB2 XML Extender
How to make a query faster.
How to call Stored Procedure from Hibernate?