bi******@in.ibm.com wrote:
hi ,
i have some simple doubt in DB2
1. can we disable or enable an INDEX.
DROP INDEX.... 2. can we drop a column from a table .
In DB2 V8 for zOS yes. In DB2 for LUW this will be supported in Viper,
today (V8.2) there is GUI driven support in the control center. 3. can we change the datatype of a column i.e say from varchar to
integer
In DB2 for LUW you can INCREASE the length of a VARCHAR column.
In Viper you will be able to do any alter which cannot cause loss of data.
VARCHAR->INTEGER: No
INTEGER->VARCHAR: I think yes in Viper.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab