MVSFORUMS.com

[danm]

A table has a column which allows null value. Is it possible to alter the table definition so null is not allowed. I look at the ALTER TABLE command, it seems it is not possible.

[kolusu]

danm,

No you Cannot. The ALTER TABLE statements that you cannot use are those that require scanning of column data to verify the validity of the alteration operations. Specifically, this means that you cannot execute the following statements on a table:

[danm]

Kolusu,

Thanks.