iAnywhere.com - Invalid data conversion: NULL was inserted for column '%1' on row %2

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

Invalid data conversion: NULL was inserted for column '%1' on row %2

Item	Value
Constant	SQLE_CANNOT_CONVERT_LOAD_TABLE
ODBC 2 State	07006
ODBC 3 State	07006
Parameter 1	Name of the column where NULL was inserted.
Parameter 2	Row number in the data file where the invalid data conversion took place.
Severity	10
SQLCODE	124
SQLSTATE	01W01
Sybase error code	13886

Probable cause

The database could not convert a value to the required type. The value being converted was supplied to the database in a data file and inserted using LOAD TABLE. A NULL value has been inserted into the column.