Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
Error 182 | "Not enough fields allocated in SQLDA" |
---|---|
Constant | SQLDA_TOO_SMALL |
SAP Sybase Error Number | 2114 |
SQL State | 07002 |
SQL Code | -182L |
ODBC 2 State | 07001 |
ODBC 3 State | 07002 |
Severity Code | |
Probable Cause | There are not enough fields in the SQLDA to retrieve all of the values requested. |
Error 183 | "Cannot find index named '%1'" |
---|---|
Constant | INDEX_NOT_FOUND |
SAP Sybase Error Number | 2063 |
SQL State | 52W03 |
SQL Code | -183L |
ODBC 2 State | S0012 |
ODBC 3 State | 42S12 |
Severity Code | |
Parameter 1 | Name of the index that cannot be found. |
Probable Cause | You attempted to perform an operation using an index that does not exist. Check for spelling errors. Check whether the index name must be qualified with a user ID. |
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" |
---|---|
Constant | COLUMN_CANNOT_BE_NULL_LOAD_TABLE |
SAP Sybase Error Number | 2531 |
SQL State | 23501 |
SQL Code | -184L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
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. |
Error 185 | "SELECT returns more than one row" |
---|---|
Constant | TOO_MANY_RECORDS |
SAP Sybase Error Number | 2116 |
SQL State | 21000 |
SQL Code | -185L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You tried to use a SELECT statement without a cursor, but the statement cursor returns more than one row. Only a single row SELECT statement can be used in this context. |
Error 186 | "Subquery cannot return more than one row" |
---|---|
Constant | SUBQUERY_RESULT_NOT_UNIQUE |
SAP Sybase Error Number | 2117 |
SQL State | 21W01 |
SQL Code | -186L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Probable Cause | You used a subquery that returns more than one row, in a context where only a single row can be used. If the subquery is in the WHERE clause, you might be able to use the IN keyword. |
Error 187 | "Illegal cursor operation attempt" |
---|---|
Constant | CURSOROP_NOT_ALLOWED |
SAP Sybase Error Number | 2118 |
SQL State | 09W02 |
SQL Code | -187L |
ODBC 2 State | 07005 |
ODBC 3 State | 07005 |
Severity Code | |
Probable Cause | You attempted an illegal cursor operation. For example, you may be attempting to OPEN a cursor for a statement that is neither a SELECT nor a BATCH. |
Error 188 | "Not enough values for host variables" |
---|---|
Constant | NOT_ENOUGH_HOST_VARS |
SAP Sybase Error Number | 2119 |
SQL State | 07001 |
SQL Code | -188L |
ODBC 2 State | 07002 |
ODBC 3 State | 07002 |
Severity Code | |
Probable Cause | You have not provided enough host variables for either the number of bind variables, or the statement, or the number of SELECT list items. |
Error 189 | "Unable to find in index '%1' for table '%2'" |
---|---|
Constant | NOT_FOUND_IN_INDEX |
SAP Sybase Error Number | 2120 |
SQL State | WI005 |
SQL Code | -189L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Name of invalid index. |
Parameter 2 | Name of table containing the invalid index. |
Probable Cause | This is an internal error. If it can be reproduced, it should be reported to iAnywhere. You should be able to work around the error by dropping and recreating the index. |
Error 190 | "Cannot update an expression" |
---|---|
Constant | NON_UPDATEABLE_COLUMN |
SAP Sybase Error Number | 2121 |
SQL State | 53W02 |
SQL Code | -190L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Probable Cause | You tried to update a column in a query that is a database expression rather than a column in a table. |
Error 191 | "Cannot modify column '%1' in table '%2'" |
---|---|
Constant | CANNOT_MODIFY |
SAP Sybase Error Number | 2122 |
SQL State | 42W32 |
SQL Code | -191L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Name of the column that cannot be changed. |
Parameter 2 | Name of the table containing the column. |
Probable Cause | You may have tried to modify a column that you do not have permission to modify. You may have tried to modify a column defined as an expression (such as column1+column2) in a view. |
Error 192 | "Update operation attempted on non-updatable query" |
---|---|
Constant | NON_UPDATEABLE_VIEW |
SAP Sybase Error Number | 2123 |
SQL State | 42W31 |
SQL Code | -192L |
ODBC 2 State | 42000 |
ODBC 3 State | 42000 |
Severity Code | |
Probable Cause | You attempted an insert, update, or delete operation on a query that is implicitly read-only. Queries that contain DISTINCT, GROUP BY, HAVING, EXCEPT, INTERSECT or UNION, or that contain aggregate functions, or that involve a join, are implicitly read-only. If the query references a view then the view may be non-updatable. |
Error 193 | "Primary key for table '%1' is not unique: Primary key value ('%2')" |
---|---|
Constant | PRIMARY_KEY_NOT_UNIQUE |
SAP Sybase Error Number | 2124 |
SQL State | 23W01 |
SQL Code | -193L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | Name of the table where the problem was detected. |
Parameter 2 | Duplicate primary key values that caused the error. |
Probable Cause | You attempted to add a new row to a table, but the new row has the same primary key as an existing row. The database has not added the incorrect row to the database. For example, you might have added a student with student number 86004 and there is already a row for a student with that number. |
Error 194 | "No primary key value for foreign key '%1' in table '%2'" |
---|---|
Constant | INVALID_FOREIGN_KEY |
SAP Sybase Error Number | 2125 |
SQL State | 23503 |
SQL Code | -194L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | Name of the foreign key. |
Parameter 2 | Name of the table with the foreign key. |
Probable Cause | You attempted to insert or update a row that has a foreign key for another table. The value for the foreign key is not NULL and there is not a corresponding value in the primary key. |
Error 195 | "Column '%1' in table '%2' cannot be NULL" |
---|---|
Constant | COLUMN_CANNOT_BE_NULL |
SAP Sybase Error Number | 2126 |
SQL State | 23502 |
SQL Code | -195L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | Name of the column that cannot be NULL. |
Parameter 2 | Name of the table containing the column. |
Probable Cause | You have not supplied a value where a value is required. The column definition prohibits NULL values or the column is part of a NOT NULL foreign key. |
Error 196 | "Index '%1' for table '%2' would not be unique" |
---|---|
Constant | INDEX_NOT_UNIQUE |
SAP Sybase Error Number | 2127 |
SQL State | 23505 |
SQL Code | -196L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | Name of the index that would not be unique. |
Parameter 2 | Name of the table that contains the index. |
Probable Cause | You attempted to insert or update a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column. |
Error 197 | "No current row of cursor" |
---|---|
Constant | NO_CURRENT_ROW |
SAP Sybase Error Number | 2128 |
SQL State | 24503 |
SQL Code | -197L |
ODBC 2 State | 24000 |
ODBC 3 State | 24000 |
Severity Code | |
Probable Cause | You attempted to perform an operation on the current row of a cursor, but the cursor is not positioned on a row. The cursor is before the first row of the cursor, after the last row, or is on a row that has since been deleted. |
Error 198 | "Primary key for row in table '%1' is referenced by foreign key '%2' in table '%3'" |
---|---|
Constant | PRIMARY_KEY_VALUE_REF |
SAP Sybase Error Number | 2129 |
SQL State | 23W05 |
SQL Code | -198L |
ODBC 2 State | 23000 |
ODBC 3 State | 23000 |
Severity Code | |
Parameter 1 | The name of the table containing the row being modified. |
Parameter 2 | The name of the foreign index (or role) of the referencing table. |
Parameter 3 | The name of the foreign table referencing the primary row. |
Probable Cause | You attempted to delete or modify a row whose primary key value is referenced elsewhere in the database. |
Error 199 | "INSERT/DELETE on cursor can modify only one table" |
---|---|
Constant | ONLY_ONE_TABLE |
SAP Sybase Error Number | 2130 |
SQL State | 09W04 |
SQL Code | -199L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Probable Cause | You attempted to insert into a cursor and have specified values for more than one table, or you attempted to delete from a cursor that involves a join. Insert into one table at a time. For DELETE, use the FROM clause to specify the table you want to delete from. |
Warning 200 | "Warning: %1" |
---|---|
Constant | WARNING |
SAP Sybase Error Number | 2009 |
SQL State | 01000 |
SQL Code | 200L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | Warning message. |
Probable Cause | A warning has occurred. The message indicates the condition that caused the warning. |
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. |