Error 184

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

Item Description

SQLCode

-184L

Constant

COLUMN_CANNOT_BE_NULL_LOAD_TABLE

SQLState

23501

ODBC 2 State

23000

ODBC 3 State

23000

Sybase Error Code

2531

Severity Code

16

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.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com