In this blog post, you’ll learn more about the Sybase Error Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1 and the reason for receiving this error
Sybase SQL Error Message
Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1
Reason for this Error
The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data. The user has to first delete the null rows before altering the column to enforce the NOT NULL constraint.