Jane,
What you were told is not true in general. This should only be the case
if you have a cyclical view, or if something like implicit type
promotion (such as varchar->long varchar due to concats) causes the
column type to change where you have a udf in the view, and implicit
recreate would cause the semantics of the view to change (conservative
bind)...I just did a quick test locally, and was able to extend the
column length with a view on the table...
My ddl was:
create table t1(c1 varchar(100))
insert some data...
create view foo(c1) as select c1 from t1
alter table t1 alter column c1 set data type varchar (200)
Ran ok...do you know if the view in question fit into one of the cases I
describe above?
Jane wrote:
Spoke to someone from IBM and I am told that if there is a view on the
table, the table columns cannot be extended.
Solution:
-Drop the view
-ALTER the table and Extend the varchar column.
Nothing is easy in DB2 ...
Thanks for everyone's input.
-Jane