I would like to export the whole content of a clob field. When I run the query

db2 "export to temp.del select char(substr(exceptiontree, 1, 100)) as clob from db2sch.logging where date(datestamp)='2008-09-30' and exceptiontree is not null"

It exports the data. However, obviously only 100 bytes.

However, if I change the size of substr to 500, I get the SQL0433N message that the value is too long

What I would like is to export the complete contents of the exceptiontree filed, is there a way of doing this?

Use the LOBSINFILE modifier.