By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,828 Members | 801 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,828 IT Pros & Developers. It's quick & easy.

CLOB data is getting truncated on SELECT

P: n/a
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.
Jan 28 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Veeru71 wrote:
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.
Jan 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.