CLOB data is getting truncated on SELECT

Veeru71 wrote:


IIRC, the DB2 CLP truncates any output >8k (presumably because most of
the time you don't want tons of CLOB stuff spilling all over the
console and filling up your scroll-back buffer :-). Not sure if there's
an option to override this (I've never seen one personally), but you
could always bash together a little script (Python, Perl, whatever
language you prefer) to extract the full value.

For reading "chunks" from a CLOB, have you tried SUBSTR?


Cheers,

Dave.