Hi,

I am using the DB2 Command Editor to run an XQuery that returns a large XML result.

the problem is that the result is truncated, so I see only a part of the XML document.

I understand that it might be the buffer size is not large enough to keep the whole result.

How can I solve this problem?

I am using DB2 express running on Ubuntu 7.04

Thank you very much in advance.
Essam

I'm not sure if this also applies to the Command Editor, but the DB2 CLP truncates LOBs and XML documents to 4 or 8K. This cannot be changed.

The background is that the CLP doesn't want to write out up to 2GB of data when a table containing such data is queried. If you need the full data, you usually have an application anyways and don't look at it on the CLP in detail.

Agree. A good alternative is to use an application(like java) to grab the result.

I am not sure whether this works: if DB2/LUW have xmlserialize or xml2clob function, you can use this function to get lob result first.

Converting XML to CLOBs is possible, of course, but you will have the limitations applicable for LOBs that I mentioned.

thank you very much.

I will try to make it using a java application.

I was using Oracle 10g, in which I can run a command to enlarge the size to let the complete result appear. I thought there is something like that in DB2.

Essam