Hi- I am new to the DB2 world. I wanted to add a not null column with a default to an existing table with data. Not realizing I could do that, I added the column as a Nullable column, updated the existing data. Now I need to add a NOT NULL constraint. Could I do that? If not, I would like to DROP the column. I tried the syntax
ALTER TABLE <tableName> DROP COLUMN <columnName>.

I get an error "SQL0104N An unexpected token "C_CNTR_VST_FR_SFE" was found following "". Expected tokens may include: "KEY "."

Any help is greatly appreciated.

Three options :

a) Export data, drop table, create table with the proper defn and load data

b) Use Control Centre to ALTER - Assuming you are 8.2+ (always mention your version and OS) , all steps in option a is done behing the scenes.

c) Add a NOT NULL CHECK Constraint on the column

Thanks Satya. Did not realize I could not DROP a column. That is kinda interesting. I will try the option A.

Thanks for your time again.

There is no "alter table drop column" in the SQL Reference manual.