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

How to Alter size of an existing Blob Column?

P: n/a
I have a blob column that is 4MB in length. I need to change it to
store a 3GIG binary.
1) What is the maximum size a BLOB column can support?
2) How do i alter the size of an existing BLOB column?
3) I have an another column that is of type LONG VARCHAR. I would like
to alter it to a CLOB as there is a size limit of 32KB on LONG VARCHAR.
What is the best way to approach this conversion?

Any help would be greatly appreciated.

Thanks,

Pradeep

Feb 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
de*******@gmail.com wrote:
I have a blob column that is 4MB in length. I need to change it to
store a 3GIG binary.
How about reading the manual as it explains which table alterations are
possible? http://publib.boulder.ibm.com/infoce.../v8//index.jsp
1) What is the maximum size a BLOB column can support?
2GB: http://tinyurl.com/b4exa
2) How do i alter the size of an existing BLOB column?
Unfortunately, this can't be done. You have to add a new column with the
proper length restriction via ALTER TABLE: http://tinyurl.com/dfxna
3) I have an another column that is of type LONG VARCHAR. I would like
to alter it to a CLOB as there is a size limit of 32KB on LONG VARCHAR.
What is the best way to approach this conversion?


EXPORT + DROP TABLE + CREATE TABLE + IMPORT (see ALTER TABLE statement)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 7 '06 #2

P: n/a
Dear Knut,

as usual, almost every answer is written in the documentation... But,
since you're so smart answering unpolitely to easy questions, coming
from dummies, why don't you have a look to my thread?

http://groups.google.it/group/comp.d...cf68f0678a4f48

The IBM documentation is not as radical as the Bible is, most of the
times.

I will anyway appreciate your help, since a stable and clear solution
is quite mandatory, at this time.

Regards.

Feb 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.