var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Altering a BLOB column length
Env: DB2 UDB v8.2, FP 7a, OS: Windows 2003 Standard Edition
Can I alter a BLOB column length? My current BLOB column length is set to 15MB, can I increase it to 20MB using Alter table statement? I couldn't find the information anywhere specific to LOBs.
I looked at the syntax diagram for ALTER TABLE .. ALTER COLUMN and it does not mention LOBS, so the answer is that you cannot change the length.
So does that mean, the only way to change it is to recreate the table and export and import the data?
Yes, but you can do it this way:
1) export data.
2) rename table
3) create new table
4) create all RI to new table
5) insert from old table or import
6) verify data
7) drop old table with new name
Use version 9 if possible. It allows many more column alterations, including changing the maximum allowed length for BLOB columns.
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Thanks for everybody's input.