CLOB data is getting truncated on SELECT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Veeru71 - 28 Jan 2008 14:31 GMT

When I am SELECT'ing a CLOB column from command prompt, the output is
getting truncated after a certail limit (8 K ??)
How do I get the full data out of a CLOB column? Are there any string
manipuration functions for CLOB fields to read it in multiple chunks ?

Thanks in advance.

Reply to this Message

Dave Hughes - 29 Jan 2008 02:13 GMT

> When I am SELECT'ing a CLOB column from command prompt, the output is
> getting truncated after a certail limit (8 K ??)
> How do I get the full data out of a CLOB column? Are there any string
> manipuration functions for CLOB fields to read it in multiple chunks ?

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.

Reply to this Message