Alter table add Boolean column with not null and default value 1 in DB2

Question

I am adding one Boolean Column(status) into table(EMPLOYEE) in DB2 with below script,

ALTER TABLE EMPLOYEE ADD status CHAR(1) not null DEFAULT '1' constraint EMPLOYEE_CK31 check (status in ('0','1'));

It is giving me error. Please let me know what is wrong in this script ?

This script worked. ALTER TABLE EMPLOYEE ADD status CHAR(1) DEFAULT '1' not null constraint EMPLOYEE_CK31 check (status in ('0','1')); — RBP
– RBP, Commented Jan 12, 2017 at 5:38

RBP · Accepted Answer · 2017-01-12 05:40:50Z

1

This script worked after changing position of Default.

ALTER TABLE EMPLOYEE ADD status CHAR(1) DEFAULT '1' not null constraint EMPLOYEE_CK31 check (status in ('0','1'));

answered Jan 12, 2017 at 5:40

RBP

4851 gold badge9 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@Esperento57 -- your comment may be correct for Postgres, but it is completely wrong for DB2 -- database in question.