A composite change to a column implies changing more than one attribute of that column in one request. NULL columns can be changed to NOT NULL, along with other attribute changes, in one request. The following example changes both the case and NULL attribute of column_2. An error is returned if abc contains any rows with nulls in column_2.
ALTER TABLE abc ADD column_2 CASESPECIFIC NOT NULL;