Error 1000063

Message text

Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1

Item

Value

SQLCode

-1000063

Constant

EMSG_COLUMNHASNULLDATA

SQLState

QDC34

ODBC State

ERROR

Probable cause

The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data in it. First delete the null rows before altering the column to enforce the NOT NULL constraint.