"Cannot specify IGNORE CONSTRAINT ALL or DATA VALUE when option CONVERSION_ERROR is on. %1"
| Item |
Description |
|
SQLCode
|
-1000166L
|
|
Constant
|
EMSG_DATAVALUE_CONVERSION_ON
|
|
SQLState
|
QDB66
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20826
|
|
Severity Code
|
14
|
|
Parameter 1
|
location of exception
|
Probable cause
When choosing to ignore DATA TYPE or ALL integrity constraint violations on LOAD command, you must also have option CONVERSION_ERROR set to 'off'.