Column '%1' in table '%2' cannot be NULL. The invalid data was supplied to LOAD TABLE in a data file on line %3

Error constant	SQLE_COLUMN_CANNOT_BE_NULL_LOAD_TABLE
ODBC 2 State	23000
ODBC 3 State	23000
Parameter 1	Name of the column that cannot be NULL.
Parameter 2	Name of the table containing the column.
Parameter 3	The line number of the data file containing the invalid data.
Severity	16
SQLCODE	–184
SQLSTATE	23501
Sybase error code	13885

Probable cause

You either have not supplied a value where a value is required or a data conversion was necessary that resulted in a NULL value. The column definition prohibits NULL values or the column is part of a NOT NULL foreign key.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.