I am pretty new to DB2 XML Extender, and I am faced with some problems.
I have a very large products table in the database, and I need to extract the whole table as an XML file on the filesystem. I am using XML collections method and have created the result table with a column whose datatype is XMLVarchar.
Is there anyway I can extract the data as an XML file without inserting into the result table??. The problem actually is , the data is so large, no matter how big the column size is, it will always give the error. The column in the result table result_tab is too small.
I definately dont want to store it in a table.

OS : solaris
DB2 version: 7.2
DB2 XML EXtender version: 7.1 + fixpack 7

Any info/link is greatly appreciated.