var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: removing not null constraint in db2.
is it possibel to delete the not null constraint in the db2? Please reply back immediately as this is urgent for us.
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.
Dropping the table level constraint is possible. but any idea why the dropping the column level setting can't be rubbed off?
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.