bikkaran@in.ibm.com wrote:

> hi ,
>
> i have some simple doubt in DB2
> 1. can we disable or enable an INDEX.

What do you have in mind with disable/enable? Should the index not be used
during queries or not being maintained during DML statements?

> 2. can we drop a column from a table .

Not yet. But the Control Center provides a way to do that.

> 3. can we change the datatype of a column i.e say from varchar to
> integer

No.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany