How to Alter size of an existing Blob Column?

[deepgun74]

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

[Knut Stolze]

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

[Marco]

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.