Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

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.