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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Column '%1' in table '%2' cannot be NULL Next Page

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


Item

Value

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.