Error 162

"Cannot convert %1 to a %2. The bad value was supplied for column '%3' on row %4 of the data file"

Item Description

SQLCode

-162L

Constant

CONVERSION_ERROR_LOAD_TABLE

SQLState

53017

ODBC 2 State

07006

ODBC 3 State

07006

Sybase Error Code

2533

Severity Code

16

Parameter 1

Value that could not be converted.

Parameter 2

Destination data type.

Parameter 3

Name of the column where the value was to be inserted.

Parameter 4

Line number of the data file where the invalid data occurred.

Probable cause

The data file supplied to LOAD TABLE contains a value that cannot be converted to the required data type.


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