[DB2EUG] ALTER TABLE QUESTION

[Sunil Inchal]

Hi group,   How do I alter column type and drop a column in DB2 using ALTER TABLE or any other command? I read in the documents that only columns with CHAR type could be altered using ALTER TABLE <tabname> ALTER COLUMN <column> ....   I want to change a SMALLINT datatype to DECIMAL(16,2). Also I need to drop an existing column. In Informix IDS it is a very easy to perform the above using ALTER command. But I don't know how to do it in DB2. Finally, what I did was backed up data using EXPORT utility, dropped the table and recreated with changed schema and reloaded the data using LOAD utility. Are there any other ways to do it?   Thanks and regards   Sunil