Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 200 | "Invalid option '%1' -- no PUBLIC setting exists" |
|---|---|
Constant | INVALID_OPTION |
SAP Sybase Error Number | 2167 |
SQL State | 42W16 |
SQL Code | -200L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the invalid option. |
Probable Cause | You may have misspelled the name of an option in the SET OPTION statement. You can only define an option for a user if the database administrator has supplied a PUBLIC value for that option. |
| Error 201 | "Invalid setting for option '%1'" |
|---|---|
Constant | INVALID_OPTION_SETTING |
SAP Sybase Error Number | 2168 |
SQL State | 42W17 |
SQL Code | -201L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the invalid option. |
Probable Cause | You supplied an invalid value for an option in the SET statement. Some options allow only numeric values, while other options allow only the values On and Off. |
| Warning 201 | "The ICU collation '%1' has defaulted to another collation" |
|---|---|
Constant | COLLATION_DEFAULT_WARNING |
SAP Sybase Error Number | 2788 |
SQL State | 01WC4 |
SQL Code | 201L |
ODBC 2 State | 01000 |
ODBC 3 State | 01000 |
Severity Code | |
Parameter 1 | The ICU collation specifier. |
Probable Cause | The specified ICU collation is not available. Another collation was substituted, which may or may not produce suitable results. Due to the structure of ICU, the collation that was used is not known, but was the best alternative to the specified collation. If this database is used on another platform, a different collation may be chosen and the operation may generate different results. |
| Error 202 | "Only PUBLIC settings are allowed for option '%1'" |
|---|---|
Constant | NOT_PUBLIC_ID |
SAP Sybase Error Number | 2251 |
SQL State | 42W43 |
SQL Code | -202L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the option. |
Probable Cause | The option specified in the SET OPTION statement is PUBLIC only. You cannot define this option for any other user. |
| Error 203 | "Cannot set a temporary option for user '%1'" |
|---|---|
Constant | TEMPORARY_NOT_ALLOWED |
SAP Sybase Error Number | 2254 |
SQL State | 42W45 |
SQL Code | -203L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | User ID whose option was to be changed. |
Probable Cause | TEMPORARY options are set on a connection basis, and only for specific options known to the database server. To change an option for another user, do not specify TEMPORARY in the SET OPTION statement. |
| Error 204 | "You do not have '%1' system privilege or authority to set the option '%2'" |
|---|---|
Constant | OPTION_REQUIRES_DBA |
SAP Sybase Error Number | 2256 |
SQL State | 42W46 |
SQL Code | -204L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the system privilege or authority required to set the option. |
Parameter 2 | Name of the option that could not be set. |
Probable Cause | The option specified in the SET OPTION statement can only be set by a user with DBA authority or by a user with SET ANY SYSTEM OPTION / SET ANY SECURITY OPTION / SET ANY PUBLIC OPTION depending on the option. |
| Error 205 | "Integrated logins are not permitted" |
|---|---|
Constant | INVALID_STANDARD_LOGON |
SAP Sybase Error Number | 2257 |
SQL State | 28W02 |
SQL Code | -205L |
ODBC 2 State | 28000 |
ODBC 3 State | 28000 |
Severity Code | |
Probable Cause | The login_mode database option is set to Standard, and you attempted an integrated login. Change the option setting or supply an explicit user ID. |
| Error 206 | "Integrated logins are required, standard logins are not permitted" |
|---|---|
Constant | INVALID_INTEGRATED_LOGON |
SAP Sybase Error Number | 2258 |
SQL State | 28W03 |
SQL Code | -206L |
ODBC 2 State | 28000 |
ODBC 3 State | 28000 |
Severity Code | |
Probable Cause | The login_mode database option is set to Integrated, and you attempted a standard login. Change the option setting or use an integrated login. |
| Error 207 | "Wrong number of values for INSERT" |
|---|---|
Constant | WRONG_NUM_OF_INSERT_COLS |
SAP Sybase Error Number | 2133 |
SQL State | 53002 |
SQL Code | -207L |
ODBC 2 State | 21S01 |
ODBC 3 State | 21S01 |
Severity Code | |
Probable Cause | The number of values you are trying to insert does not match the number of columns specified in the INSERT statement, or the number of columns in the table if no columns are specified. |
| Error 208 | "Row has changed since last read -- operation canceled" |
|---|---|
Constant | ROW_UPDATED_SINCE_READ |
SAP Sybase Error Number | 2132 |
SQL State | 22W02 |
SQL Code | -208L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You attempted an UPDATE (positioned) or DELETE (positioned) operation on a cursor declared as a SCROLL cursor, and the row you are changing has been updated since you read it. This error prevents the lost update problem. |
| Error 209 | "Constraint '%1' violated: Invalid value for column '%2' in table '%3'" |
|---|---|
Constant | INVALID_COLUMN_VALUE |
SAP Sybase Error Number | 2131 |
SQL State | 23506 |
SQL Code | -209L |
ODBC 2 State | 42000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | Name of the constraint (if defined) that was violated by an invalid value. |
Parameter 2 | Name of the column that was assigned an invalid value. |
Parameter 3 | Name of the table containing the column. |
Probable Cause | You attempted an insert or update that violates a CHECK constraint. A CHECK constraint is violated if it evaluates to FALSE; it is deemed to hold if the condition evaluates to TRUE or UNKNOWN. |
| Error 210 | "User '%1' has the row in '%2' locked" |
|---|---|
Constant | LOCKED |
SAP Sybase Error Number | 2169 |
SQL State | 42W18 |
SQL Code | -210L |
ODBC 2 State | 40001 |
ODBC 3 State | 40001 |
Severity Code | |
Parameter 1 | Name of another user. |
Parameter 2 | Table that generates the error. |
Probable Cause | The operation failed because another connection holds a lock on the same object you are attempting to modify. With INSERT, UPDATE, DELETE, SELECT, or MERGE statements this error is typically caused by attempting to read or write a row that is locked by another user, while the database option 'blocking' is set to Off. With data definition statements, including CREATE, DROP, GRANT, REVOKE, REFRESH, or ALTER, this error can be generated when the connection executing the DDL statement is unable to obtain an exclusive lock on the object to be modified (table, view, materialized view, or index) so that the operation can proceed. |
| Error 211 | "Not allowed while '%1' is using the database" |
|---|---|
Constant | MUST_BE_ONLY_CONNECTION |
SAP Sybase Error Number | 2170 |
SQL State | 42W19 |
SQL Code | -211L |
ODBC 2 State | 40001 |
ODBC 3 State | 40001 |
Severity Code | |
Parameter 1 | Name of the connection that is using the database. |
Probable Cause | You attempted a data definition language operation that cannot be completed while another user is connected. |
| Error 212 | "CHECKPOINT statement requires a rollback log" |
|---|---|
Constant | CHECKPOINT_REQUIRES_UNDO |
SAP Sybase Error Number | 2171 |
SQL State | 42W20 |
SQL Code | -212L |
ODBC 2 State | 40001 |
ODBC 3 State | 40001 |
Severity Code | |
Probable Cause | You cannot use a CHECKPOINT statement when the database server is running in bulk mode without a rollback log. |
| Error 213 | "Savepoints require a rollback log" |
|---|---|
Constant | SAVEPOINTS_REQUIRE_UNDO |
SAP Sybase Error Number | 2177 |
SQL State | 3BW01 |
SQL Code | -213L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You cannot use savepoints when the database server is running in bulk mode without a rollback log. |
| Error 214 | "Table in use" |
|---|---|
Constant | TABLE_IN_USE |
SAP Sybase Error Number | 2172 |
SQL State | 42W21 |
SQL Code | -214L |
ODBC 2 State | 40001 |
ODBC 3 State | 40001 |
Severity Code | |
Probable Cause | You attempted to ALTER or DROP a table that is being used by other active users of the database. |
| Error 215 | "Procedure in use by '%1'" |
|---|---|
Constant | PROCEDURE_IN_USE |
SAP Sybase Error Number | 2173 |
SQL State | 42W23 |
SQL Code | -215L |
ODBC 2 State | 40001 |
ODBC 3 State | 40001 |
Severity Code | |
Parameter 1 | Name of user. |
Probable Cause | You attempted to DROP a procedure that is being used by other active users of the database. |
| Error 216 | "The option '%1' can only be set as a temporary option" |
|---|---|
Constant | OPTION_IS_TEMP_ONLY |
SAP Sybase Error Number | 2351 |
SQL State | 42W52 |
SQL Code | -216L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the option that could not be set. |
Probable Cause | The option specified in the SET OPTION statement can only be set as a temporary option. |
| Error 217 | "The option '%1' cannot be set from within a procedure" |
|---|---|
Constant | OPTION_IN_PROCEDURE |
SAP Sybase Error Number | 2352 |
SQL State | 42W53 |
SQL Code | -217L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the option that could not be set. |
Probable Cause | The option specified in the SET OPTION statement cannot be set from within a procedure. |
| Error 218 | "Authentication failed" |
|---|---|
Constant | AUTHENTICATION_FAILED |
SAP Sybase Error Number | 2353 |
SQL State | 08W48 |
SQL Code | -218L |
ODBC 2 State | 08001 |
ODBC 3 State | 08001 |
Severity Code | |
Probable Cause | You set the database_authentication or connection_authentication option incorrectly. |