Kbase P96693: SQL-92: Is Alter table add column with BLOB or CLOB supported when used in a Online Schema change?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/10/2004 |
|
Status: Unverified
GOAL:
Using JDBC or ODBC Client
GOAL:
Using ALTER TABLE ADD COLUMN which the column has to be defined as CLOB or BLOB
GOAL:
ALTER TABLE is performed using Online Schema Change feature
GOAL:
Is ALTER TABLE ADD COLUMN is supported in the above scenario?
FACT(s) (Environment):
OpenEdge 10.0x
FIX:
No, with the current implementation, the ALTER TABLE ADD COLUMN with CLOB or BLOB datatype is not supported when performed while the Database is in use (using Online Schema Change feature)