is it possibel to delete the not null constraint in the db2? Please reply back immediately as this is urgent for us.

Regards
Shrini

In DB2 z/OS: no if you talk about a column defined as NOT NULL. If you ensure it through a table constraint, then you can drop that constraint.

Thanks Walter
Dropping the table level constraint is possible. but any idea why the dropping the column level setting can't be rubbed off?

Regards
Shrini

Hi

I don't know, if my reply was clear. If you create your table as
CREATE TABLE T1 ... COL1 SMALLINT NOT NULL, then you cannot change the null constraint, because DB2 does not offer this feature.

If you create your table with CREATE TABLE T1 ... COL1 SMALLINT CHECK (COL1 IS NOT NULL) then you can drop this check constraint, by using ALTER TABLE T1 DROP constraintname.