This section provides a full listing of error messages and descriptions.
Errors with an ODBC state marked "handled by ODBC driver" are not returned to ODBC applications, as the ODBC driver carries out the required actions.
Item | Value |
---|---|
SQLCode | 0 |
Constant | SQLE_NOERROR |
SQLState | 00000 |
ODBC State | 00000 |
This code indicates that there was no error or warning.
Item | Value |
---|---|
SQLCode | -624 |
Constant | SQLE_DATATYPE_NOT_ALLOWED |
SQLState | WW009 |
ODBC State | S1000 |
A parameter to a call to an external function is declared to be a datatype that is not supported.
Item | Value |
---|---|
SQLCode | -626 |
Constant | SQLE_THREAD_START_FAILURE |
SQLState | WW011 |
ODBC State | S1000 |
This is a Windows95 specific error. An operating system thread could not be started that is required to execute external functions.
Item | Value |
---|---|
SQLCode | -150 |
Constant | SQLE_AGGREGATES_NOT_ALLOWED |
SQLState | 42W06 |
ODBC State | 37000 |
An UPDATE statement has used an aggregate function (MIN, MAX, SUM, AVG or COUNT).
Item | Value |
---|---|
SQLCode | -307 |
Constant | SQLE_THREAD_DEADLOCK |
SQLState | 40W06 |
ODBC State | 40001 |
You have attempted to read or write a row and it is locked by another user. Also, all other threads (see database option THREAD_COUNT) are blocked waiting for a lock to be released. This is a deadlock situation and your transaction has been chosen as the one to rollback.
Item | Value |
---|---|
SQLCode | -125 |
Constant | SQLE_ALTER_CLAUSE_CONFLICT |
SQLState | 53W01 |
ODBC State | S1000 |
A primary key clause, foreign key clause, or a uniqueness clause must be the only clause of an ALTER TABLE command.
Item | Value |
---|---|
SQLCode | -407 |
Constant | SQLE_HLI_BAD_ARGUMENT |
SQLState | 22W01 |
ODBC State | 22W01 |
One of the arguments passed to a WSQL HLI function was invalid. This may indicate that a pointer to a command string or result buffer is the null pointer.
Item | Value |
---|---|
SQLCode | -298 |
Constant | SQLE_DOUBLE_REQUEST |
SQLState | 42W22 |
ODBC State | S1000 |
In Embedded SQL, you have attempted to submit a database request while you have another request in process. This often occurs in Windows when processing the WM_PAINT message causes a database request, and you get a second WM_PAINT before the database request has completed.
Item | Value |
---|---|
SQLCode | -98 |
Constant | SQLE_AUTHENTICATION_VIOLATION |
SQLState | 08W21 |
ODBC State | 08001 |
You have attempted to connect to an engine or server which has been authenticated for exclusive use with a specific application.
Item | Value |
---|---|
SQLCode | -617 |
Constant | SQLE_EXTERNAL_CALLS_NOT_SUPPORTED |
SQLState | WW003 |
ODBC State | S1000 |
An attempt was made to call a stored procedure that, in turn, calls a function in a dynamically loaded module. The operating system on which this stored procedure was called does not support such an action.
Item | Value |
---|---|
SQLCode | -160 |
Constant | SQLE_DESCRIBE_NONSELECT |
SQLState | 07005 |
ODBC State | (handled by ODBC driver) |
In the C language interface, you attempted to describe the select list of a statement other than a SELECT statement.
Item | Value |
---|---|
SQLCode | -127 |
Constant | SQLE_COLUMN_IN_INDEX |
SQLState | 53W05 |
ODBC State | S1000 |
This error is reported if you attempt to delete or modify the definition of a column that is part of a primary or foreign key. This error will also be reported if you attempt to delete a column that has an index on it. DROP the index or key, perform the ALTER command, and then add the index or key again.
Item | Value |
---|---|
SQLCode | -105 |
Constant | SQLE_UNABLE_TO_CONNECT |
SQLState | 08001 |
ODBC State | 08001 |
Parameter 1 | Name of database. |
The specified database environment cannot be found. If it is a database name, then it does not exist, it is not a database, it is corrupt, or it is an older format. If it is a server name, then the server cannot be found.
Item | Value |
---|---|
SQLCode | -157 |
Constant | SQLE_CONVERSION_ERROR |
SQLState | 53018 |
ODBC State | 07006 |
Parameter 1 | The value that could not be converted. |
Parameter 2 | The name of the type for the conversion. |
An invalid value has been supplied to or fetched from the database. For example, the value 12X might have been supplied where a number was required.
Item | Value |
---|---|
SQLCode | -269 |
Constant | SQLE_COLUMN_IN_TRIGGER |
SQLState | 53W06 |
ODBC State | S1000 |
This error is reported if you attempt to delete a column that is referenced in a trigger definition. DROP the trigger before performing the ALTER command.
Item | Value |
---|---|
SQLCode | -614 |
Constant | SQLE_USER_OWNS_MESSAGES_OR_DATATYPES |
SQLState | 55W05 |
ODBC State | 37000 |
A user to be dropped is the creator of a message or user-defined datatype. The message or user-defined datatype must be dropped first.
Item | Value |
---|---|
SQLCode | -270 |
Constant | SQLE_USER_OWNS_PROCEDURES |
SQLState | 55W04 |
ODBC State | 37000 |
This error is reported by the runtime engine if you attempt to drop a user that owns procedures. Because this operation would result in dropping procedures, and the runtime engine cannot drop procedures, it is not allowed. Use the full engine.
Item | Value |
---|---|
SQLCode | -128 |
Constant | SQLE_USER_OWNS_TABLES |
SQLState | 55W03 |
ODBC State | 37000 |
This error is reported by the runtime engine if you attempt to drop a user that owns tables. Because this operation would result in dropping tables, and the runtime engine cannot drop tables, it is not allowed. Use the full engine.
Item | Value |
---|---|
SQLCode | -183 |
Constant | SQLE_INDEX_NOT_FOUND |
SQLState | 52W03 |
ODBC State | S0012 |
Parameter 1 | Name of the index that cannot be found. |
A DROP INDEX command has named an index that does not exist. Check for spelling errors or whether the index name must be qualified by a userid.
Item | Value |
---|---|
SQLCode | -248 |
Constant | SQLE_INTEGRATED_LOGON_SYSMAP |
SQLState | 28W07 |
ODBC State | 28000 |
The dba attempted to map a loginID to either sys or public
Item | Value |
---|---|
SQLCode | -191 |
Constant | SQLE_CANNOT_MODIFY |
SQLState | 42W32 |
ODBC State | 42032 |
Parameter 1 | Name of the column that cannot be changed. |
Parameter 2 | Name of the table containing the column. |
You do not have permission to modify the column, or the table is actually a view and the column in the view is defined as an expression (such as column1+column2) that cannot be modified.
Item | Value |
---|---|
SQLCode | -106 |
Constant | SQLE_CANNOT_OPEN_LOG |
SQLState | 08W05 |
ODBC State | 08003 |
Parameter 1 | Name of log file. |
The database engine was unable to open the transaction log file. Perhaps the log file name specifies an invalid device or directory. If this is the case, you can use the DBLOG utility to find out where the transaction log should be and perhaps change it.
Item | Value |
---|---|
SQLCode | -162 |
Constant | SQLE_CANNOT_OUTER_JOIN |
SQLState | 52W19 |
ODBC State | 37000 |
A view that contains a UNION or view cannot be used on the right of a LEFT OUTER JOIN or on the left of a RIGHT OUTER JOIN.
Item | Value |
---|---|
SQLCode | -203 |
Constant | SQLE_TEMPORARY_NOT_ALLOWED |
SQLState | 42W45 |
ODBC State | 37000 |
Parameter 1 | Userid whose option was to be changed. |
TEMPORARY options are set on a connection basis. To change an option for another user, do not specify TEMPORARY in the SET OPTION statement.
Item | Value |
---|---|
SQLCode | -295 |
Constant | SQLE_CANNOT_UNIQUELY_IDENTIFY_ROWS |
SQLState | 09W05 |
ODBC State | 24000 |
A UNIQUE cursor has been opened on a SELECT statement for which a set of columns uniquely identifying each row cannot be generated. One of the tables may not be defined with a primary key or uniqueness constraint, or the SELECT statement may involve a UNION or GROUP BY.
Item | Value |
---|---|
SQLCode | -190 |
Constant | SQLE_NON_UPDATEABLE_COLUMN |
SQLState | 53W02 |
ODBC State | 37000 |
You have tried to update a column in a query that is a database expression rather than a column in a table.
Item | Value |
---|---|
SQLCode | -212 |
Constant | SQLE_CHECKPOINT_REQUIRES_UNDO |
SQLState | 42W20 |
ODBC State | 40001 |
You cannot use a CHECKPOINT command when the database engine is running in bulk mode without a rollback log.
Item | Value |
---|---|
SQLCode | -88 |
Constant | SQLE_PROTOCOL_MISMATCH |
SQLState | 08W15 |
ODBC State | 08S01 |
The multiuser client was unable to start because the protocol versions of the client and the running server do not match. Make sure the client and server software are the same version.
Item | Value |
---|---|
SQLCode | -113 |
Constant | SQLE_INVALID_FOREIGN_KEY_DEF |
SQLState | 53030 |
ODBC State | 23000 |
Parameter 1 | Name of the problem column. |
The data type of the column in the foreign key is not the same as the data type of the column in the primary key. Change the definition of one of the columns using ALTER TABLE.
Item | Value |
---|---|
SQLCode | -144 |
Constant | SQLE_COLUMN_AMBIGUOUS |
SQLState | 52002 |
ODBC State | SJS01 |
Parameter 1 | Name of the ambiguous column. |
You have not put a correlation name on a column that is found in more than one of the tables referenced in a query. You need to add a correlation name to the reference.
Item | Value |
---|---|
SQLCode | -195 |
Constant | SQLE_COLUMN_CANNOT_BE_NULL |
SQLState | 23502 |
ODBC State | 23000 |
Parameter 1 | Name of the column that cannot be NULL. |
Parameter 2 | Name of the table containing the column. |
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.
Item | Value |
---|---|
SQLCode | -143 |
Constant | SQLE_COLUMN_NOT_FOUND |
SQLState | 52003 |
ODBC State | S0022 |
Parameter 1 | Name of the column that could not be found. |
You have misspelled the name of a column, or the column you are looking for is in a different table.
Item | Value |
---|---|
SQLCode | -267 |
Constant | SQLE_ATOMIC_OPERATION |
SQLState | 42W28 |
ODBC State | 37000 |
A COMMIT or ROLLBACK statement was encountered while executing within an atomic operation.
Item | Value |
---|---|
SQLCode | -273 |
Constant | SQLE_INVALID_TRIGGER_STATEMENT |
SQLState | 2D501 |
ODBC State | 37000 |
An attempt was made to execute a statement that is not allowed while performing a trigger action. COMMIT and ROLLBACK statements cannot be executed from a trigger.
Item | Value |
---|---|
SQLCode | -73 |
Constant | SQLE_COMMUNICATIONS_UNDERFLOW |
SQLState | 08W31 |
ODBC State | 08S01 |
The multiuser client or server has received a network buffer containing insufficient data. If this error occurs, it should be reported to Watcom.
Item | Value |
---|---|
SQLCode | -85 |
Constant | SQLE_COMMUNICATIONS_ERROR |
SQLState | 08W12 |
ODBC State | 08S01 |
There is a communication problem between the multiuser client and server. This happens most frequently when the multiuser client was unable to start because a communication error occurred while trying to locate the server.
Item | Value |
---|---|
SQLCode | -108 |
Constant | SQLE_CONNECTION_NOT_FOUND |
SQLState | 08W02 |
ODBC State | 08003 |
The specified connection name on a DISCONNECT or SET CONNECTION statement is invalid.
Item | Value |
---|---|
SQLCode | -308 |
Constant | SQLE_CONNECTION_TERMINATED |
SQLState | 40W07 |
ODBC State | S1000 |
Your database connection has been terminated by a DBA executing a DROP CONNECTION command. Your transaction was rolled back.
Item | Value |
---|---|
SQLCode | -99 |
Constant | SQLE_CONNECTIONS_DISABLED |
SQLState | 08W04 |
ODBC State | 08005 |
Connections to the multiuser server have been disabled on the server console. You will receive this error until they have been reenabled on the server console.
Item | Value |
---|---|
SQLCode | -142 |
Constant | SQLE_CORRELATION_NAME_NOT_FOUND |
SQLState | 52W02 |
ODBC State | S0002 |
Parameter 1 | Name of the invalid correlation name. |
You have misspelled a correlation name, or you have used a table name instead of the correlation name.
Item | Value |
---|---|
SQLCode | -622 |
Constant | SQLE_ERROR_CALLING_FUNCTION |
SQLState | WW008 |
ODBC State | S1000 |
The external function could not be called due to a shortage of operating system resources. If the operating system supports threads, the maximum thread count should be increased.
Item | Value |
---|---|
SQLCode | -621 |
Constant | SQLE_COULD_NOT_FIND_FUNCTION |
SQLState | WW007 |
ODBC State | S1000 |
The external function could not be found in the dynamic library.
Item | Value |
---|---|
SQLCode | -620 |
Constant | SQLE_COULD_NOT_LOAD_LIBRARY |
SQLState | WW006 |
ODBC State | S1000 |
The library named in an external function call could not be loaded.
Item | Value |
---|---|
SQLCode | -172 |
Constant | SQLE_CURSOR_ALREADY_OPEN |
SQLState | 24502 |
ODBC State | 24000 |
You attempted to OPEN a cursor that is already open.
Item | Value |
---|---|
SQLCode | -170 |
Constant | SQLE_CURSOR_NOT_DECLARED |
SQLState | 24W01 |
ODBC State | 24000 |
You attempted to OPEN a cursor that has not been declared.
Item | Value |
---|---|
SQLCode | -180 |
Constant | SQLE_CURSOR_NOT_OPEN |
SQLState | 24501 |
ODBC State | 34000 |
You attempted to OPEN a cursor that has not been declared.
Item | Value |
---|---|
SQLCode | 108 |
Constant | SQLE_CURSOR_OPERATION_CONFLICT |
SQLState | 01001 |
ODBC State | (handled by ODBC driver) |
You have attempted to perform an operation on the current row of a cursor, but the row has been modified by a searched UPDATE or DELETE or by a positioned UPDATE or DELETE.
Item | Value |
---|---|
SQLCode | -623 |
Constant | SQLE_DDL_NOT_ALLOWED_IN_PROCEDURES |
SQLState | 52W21 |
ODBC State | S1000 |
The procedure or trigger definition contains a data definition statement (such as CREATE, DROP, GRANT, REVOKE, ALTER). These statements are not allowed within procedures or triggers.
Item | Value |
---|---|
SQLCode | -241 |
Constant | SQLE_BACKUP_NOT_STARTED |
SQLState | WB002 |
ODBC State | S1000 |
A database backup could not be started. Either you do not have DBA authority, or another backup has started and not completed.
Item | Value |
---|---|
SQLCode | -645 |
Constant | SQLE_DATABASE_NOT_CREATED |
SQLState | 08W33 |
ODBC State | 08004 |
An attempt to initialize a file for database creation failed.
Item | Value |
---|---|
SQLCode | -96 |
Constant | SQLE_ENGINE_ALREADY_RUNNING |
SQLState | 08W23 |
ODBC State | S1000 |
The database engine was not able to start on a db_start_engine call because it was already running.
Item | Value |
---|---|
SQLCode | -100 |
Constant | SQLE_ENGINE_NOT_RUNNING |
SQLState | 08W01 |
ODBC State | 08001 |
You have not run the database engine or network requestor or the interface library is unable to find it.
Item | Value |
---|---|
SQLCode | -89 |
Constant | SQLE_ENGINE_NOT_MULTIUSER |
SQLState | 08W16 |
ODBC State | 08001 |
The database was started for bulk loading (the -b switch) and cannot be used as a multiuser engine. Stop the database, and start again without -b. In the DOS version of Watcom SQL 3.0, the database engine was not started in multiuser mode.
Item | Value |
---|---|
SQLCode | -77 |
Constant | SQLE_ALIAS_CLASH |
SQLState | 08W27 |
ODBC State | 08001 |
The database cannot be loaded as its name is conflicting with a previously loaded database.
Item | Value |
---|---|
SQLCode | -87 |
Constant | SQLE_DATABASE_NAME_REQUIRED |
SQLState | 08W14 |
ODBC State | 08001 |
A database name is required to start the database engine or the multiuser client, but it was not specified.
Item | Value |
---|---|
SQLCode | 113 |
Constant | SQLE_INVALID_OPTION_ON_CONNECT |
SQLState | 01W11 |
ODBC State | (handled by ODBC driver) |
Parameter 1 | Name of the database option that has the invalid value. |
Parameter 2 | Name of the user attempting to connect. |
Upon processing a connection request for a specific user, the engine processed a database option from the SYSOPTIONS table which had an invalid setting. The erroneous option setting is ignored; in its place, the engine will use the default option value for the current database.
Item | Value |
---|---|
SQLCode | -266 |
Constant | SQLE_OLD_DBINIT |
SQLState | 42W27 |
ODBC State | 37000 |
The database is missing some system table definitions required for this statement. These system table definitions are normally created when a database is initialized. The database should be unloaded and reloaded into a database that has been initialized with a newer version of SQL Anywhere or use DBUPGRADE to upgrade the database to the most recent version.
Item | Value |
---|---|
SQLCode | -97 |
Constant | SQLE_PAGE_SIZE_TOO_BIG |
SQLState | 08W22 |
ODBC State | 08004 |
You have attempted to start a database with a page size that exceeds the maximum page size of the running engine. Restart the engine with this database named on the command line.
Item | Value |
---|---|
SQLCode | -231 |
Constant | SQLE_DBLIB_ENGINE_MISMATCH |
SQLState | 08W19 |
ODBC State | 08001 |
Your executable uses a database interface library that does not match the version number of the database engine.
Item | Value |
---|---|
SQLCode | -138 |
Constant | SQLE_DBSPACE_NOT_FOUND |
SQLState | 52W13 |
ODBC State | S0002 |
Parameter 1 | Name of the dbspace that could not be found. |
The named dbspace was not found.
Item | Value |
---|---|
SQLCode | -306 |
Constant | SQLE_DEADLOCK |
SQLState | 40001 |
ODBC State | 40001 |
You have attempted to read or write a row and it is locked by another user. Also, the other user is blocked directly or indirectly on your own transaction. This is a deadlock situation and your transaction has been chosen as the one to rollback.
Item | Value |
---|---|
SQLCode | -627 |
Constant | SQLE_INVALID_SYNTAX_EXTENSION |
SQLState | 0AW03 |
ODBC State | S1000 |
Parameter 1 | The word or symbol where the syntax has been detected. |
The command you are trying to execute contains extensions to ANSI 1992 Entry SQL that are not allowed by the current settings.
Item | Value |
---|---|
SQLCode | -304 |
Constant | SQLE_DEVICE_FULL |
SQLState | 40W03 |
ODBC State | S1000 |
Your hard disk is out of free space. A ROLLBACK WORK command has been automatically executed.
Item | Value |
---|---|
SQLCode | -628 |
Constant | SQLE_DIV_ZERO_ERROR |
SQLState | 22012 |
ODBC State | 22012 |
A division by zero operation was detected.
Item | Value |
---|---|
SQLCode | -121 |
Constant | SQLE_PERMISSION_DENIED |
SQLState | 42501 |
ODBC State | 42000 |
Parameter 1 | Description of the type of permission lacking. |
You do not have the required permission to do the specified action. You have not been granted permission to use a table belonging to another userid.
Item | Value |
---|---|
SQLCode | -637 |
Constant | SQLE_DUPLICATE_INSERT_COLUMN |
SQLState | 42W41 |
ODBC State | 42000 |
A duplicate column name was used in the list of insert columns.
Item | Value |
---|---|
SQLCode | -636 |
Constant | SQLE_DUPLICATE_REFERENCING_COLUMN |
SQLState | 42W40 |
ODBC State | 42000 |
A duplicate column name was used in the list of referencing columns.
Item | Value |
---|---|
SQLCode | -78 |
Constant | SQLE_DYNAMIC_MEMORY_EXHAUSTED |
SQLState | 08W26 |
ODBC State | S1001 |
A failure occurred when trying to allocate dynamic memory.
Item | Value |
---|---|
SQLCode | -641 |
Constant | SQLE_ERROR_IN_ASSIGNMENT |
SQLState | 22005 |
ODBC State | 22005 |
In a GET DESCRIPTOR statement, the data type of the host variable must correspond to the data type of the descriptor item.
Item | Value |
---|---|
SQLCode | -184 |
Constant | SQLE_PUT_CURSOR_ERROR |
SQLState | 09W01 |
ODBC State | S1000 |
An error has occurred while inserting into a cursor.
Item | Value |
---|---|
SQLCode | -296 |
Constant | SQLE_ERROR_NUMBER_OUT_OF_RANGE |
SQLState | 53W07 |
ODBC State | 37000 |
Parameter 1 | Error number. |
The error number used in a RAISERROR statement is invalid. The number must be greater than or equal to 17000.
Item | Value |
---|---|
SQLCode | -171 |
Constant | SQLE_OPEN_CURSOR_ERROR |
SQLState | 07003 |
ODBC State | 24000 |
You have attempted to open a cursor on a statement that is not a SELECT statement or a CALL statement.
Item | Value |
---|---|
SQLCode | -107 |
Constant | SQLE_ERROR_WRITING_LOG |
SQLState | 08W17 |
ODBC State | S1000 |
The database engine got an I/O error writing the log file. Perhaps the disk is full or the log file name is invalid.
Item | Value |
---|---|
SQLCode | -134 |
Constant | SQLE_NOT_IMPLEMENTED |
SQLState | 0A000 |
ODBC State | S1000 |
Parameter 1 | The unimplemented feature. |
The requested operation or feature is not implemented in SQL Anywhere.
Item | Value |
---|---|
SQLCode | -251 |
Constant | SQLE_DUPLICATE_FOREIGN_KEY |
SQLState | 52W06 |
ODBC State | 23000 |
Parameter 1 | The role name of the new foreign key. |
Parameter 2 | The table containing the foreign key. |
You have attempted to define a foreign key that already exists.
Item | Value |
---|---|
SQLCode | -145 |
Constant | SQLE_FOREIGN_KEY_NAME_NOT_FOUND |
SQLState | 52W07 |
ODBC State | 37000 |
Parameter 1 | Name of the non-existing foreign key. |
You have misspelled the name of a foreign key or the foreign key does not exist.
Item | Value |
---|---|
SQLCode | -294 |
Constant | SQLE_INVALID_FORMAT_STRING_ARG_NUM |
SQLState | 53W08 |
ODBC State | 37000 |
Parameter 1 | Argument number. |
An argument number in the format string for a PRINT or RAISERROR statement is invalid. The number must be between 1 and 20 and must not exceed the number of arguments provided.
Item | Value |
---|---|
SQLCode | -149 |
Constant | SQLE_INVALID_GROUP_SELECT |
SQLState | 53003 |
ODBC State | 37000 |
Parameter 1 | Name of the column referenced directly, or in an expression, that must be in the GROUP BY clause. |
In a query using GROUP BY, select list items that are not aggregate functions must also appear in the GROUP BY clause. If the select list item is a column reference or an alias, simply add the column name or alias to the GROUP BY clause. If the select list item is a scalar function, ensure that the function's arguments in the GROUP BY clause match exactly with those in the select list. In some cases, you may want to use the MAX function on the column name (or another aggregate function) instead of adding the column to the GROUP BY clause.
Item | Value |
---|---|
SQLCode | -635 |
Constant | SQLE_NO_COLUMN_PERMS_FOR_VIEWS |
SQLState | 52W22 |
ODBC State | S1000 |
Permissions on columns cannot be granted for views.
Item | Value |
---|---|
SQLCode | -305 |
Constant | SQLE_DEVICE_ERROR |
SQLState | 40W04 |
ODBC State | S1000 |
SQL Anywhere has detected a problem with your hard disk. If you cannot find a hardware error using the operating system disk check utility (eg. in DOS, chkdsk, and in QNX, chkfsys), report the problem to SQL Anywhere technical support. A ROLLBACK WORK command has been automatically executed.
Item | Value |
---|---|
SQLCode | -250 |
Constant | SQLE_IDENTIFIER_TOO_LONG |
SQLState | 54003 |
ODBC State | 37000 |
Parameter 1 | The identifier in error. |
An identifier is longer than 128 characters.
Item | Value |
---|---|
SQLCode | -242 |
Constant | SQLE_BACKUP_CANNOT_RENAME_LOG_YET |
SQLState | WB003 |
ODBC State | S1000 |
The last page in the transaction log was read by a call to db_backup. One or more currently active connections have partially completed transactions, preventing the transaction log file from being renamed. The db_backup call should be reissued.
Item | Value |
---|---|
SQLCode | -196 |
Constant | SQLE_INDEX_NOT_UNIQUE |
SQLState | 23505 |
ODBC State | 23000 |
Parameter 1 | Name of the index that would not be unique. |
Parameter 2 | Name of the table that contains the index. |
You have inserted or updated 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.
Item | Value |
---|---|
SQLCode | -111 |
Constant | SQLE_INDEX_NAME_NOT_UNIQUE |
SQLState | 52W04 |
ODBC State | S0011 |
Parameter 1 | Name of the invalid index. |
You have attempted to create an index with a name of an existing index.
Item | Value |
---|---|
SQLCode | -199 |
Constant | SQLE_ONLY_ONE_TABLE |
SQLState | 09W04 |
ODBC State | 37000 |
You have attempted to INSERT into a cursor and have specified values for more than one table; or you have tried to DELETE from a cursor that involves a join. INSERT into one table at a time. For DELETE, use the FROM clause to specify which table you wish to delete from.
Item | Value |
---|---|
SQLCode | -245 |
Constant | SQLE_INTEGRATED_LOGON_FAILED |
SQLState | 28W04 |
ODBC State | 28000 |
The integrated logon failed, possibly because if the user doesn't have a system account on the server machine, or for other reasons.
Item | Value |
---|---|
SQLCode | -205 |
Constant | SQLE_INVALID_STANDARD_LOGON |
SQLState | 28W02 |
ODBC State | 28000 |
The engine logon type switch (gl) is set to STANDARD logon type, and the user has attempted an integrated logon.
Item | Value |
---|---|
SQLCode | -246 |
Constant | SQLE_INTEGRATED_LOGON_UNSUPPORTED |
SQLState | 28W05 |
ODBC State | 28000 |
The current database is an older database and does not have a sys.syslogin table to map integrated loginIDs to database userIDs.
Item | Value |
---|---|
SQLCode | -301 |
Constant | SQLE_DATABASE_ERROR |
SQLState | 40W01 |
ODBC State | S1000 |
Parameter 1 | Identification of the error. |
This error indicates an internal database error, and should be reported to SQL Anywhere technical support. A ROLLBACK WORK command has been automatically executed.
Item | Value |
---|---|
SQLCode | -263 |
Constant | SQLE_INVALID_FETCH_POSITION |
SQLState | 42W25 |
ODBC State | 37000 |
The offset specified in a FETCH was invalid or NULL.
Item | Value |
---|---|
SQLCode | -159 |
Constant | SQLE_INVALID_COLUMN_NUMBER |
SQLState | 42W13 |
ODBC State | S1000 |
The column number in a GET DATA command is invalid.
Item | Value |
---|---|
SQLCode | 103 |
Constant | SQLE_CANNOT_CONVERT |
SQLState | 01W03 |
ODBC State | 07006 |
The database could not convert a value to the required type. This is either a value supplied to the database on an insert, update or as a host bind variable, or a value retrieved from the database into a host variable or SQLDA.
Item | Value |
---|---|
SQLCode | -81 |
Constant | SQLE_INVALID_COMMAND_LINE |
SQLState | 08W08 |
ODBC State | 08001 |
It was not possible to start the database engine or multiuser client because the command line was invalid. of how the engine is started.
Item | Value |
---|---|
SQLCode | -644 |
Constant | SQLE_PAGE_SIZE_INVALID |
SQLState | 08W32 |
ODBC State | 08004 |
You have attempted to create a database with an invalid page size.
Item | Value |
---|---|
SQLCode | -609 |
Constant | SQLE_INVALID_TEXT_IMAGE_DATATYPE |
SQLState | 53W09 |
ODBC State | S1000 |
The column referenced in a WRITETEXT or READTEXT statement is not defined for storing text or image data.
Item | Value |
---|---|
SQLCode | -640 |
Constant | SQLE_INVALID_DESCRIPTOR_INDEX |
SQLState | 07009 |
ODBC State | 07009 |
The index number used with respect to a descriptor area is out of range.
Item | Value |
---|---|
SQLCode | -629 |
Constant | SQLE_INVALID_ESCAPE_CHAR |
SQLState | 22019 |
ODBC State | 22019 |
Escape character string length must be exactly one.
Item | Value |
---|---|
SQLCode | -630 |
Constant | SQLE_INVALID_ESCAPE_SEQ |
SQLState | 22025 |
ODBC State | 22025 |
LIKE pattern contains an invalid use of the escape character. The escape character may only precede the special characters '%', '_', '[', and the escape character itself.
Item | Value |
---|---|
SQLCode | -156 |
Constant | SQLE_EXPRESSION_ERROR |
SQLState | 42W08 |
ODBC State | 37000 |
Parameter 1 | The invalid expression. |
You have an expression which the database engine cannot understand. For example, you might have tried to add two dates.
Item | Value |
---|---|
SQLCode | -155 |
Constant | SQLE_VARIABLE_INVALID |
SQLState | 42W07 |
ODBC State | 37000 |
A host variable supplied to the database using the C language interface as either a host variable or through an SQLDA is invalid.
Item | Value |
---|---|
SQLCode | -79 |
Constant | SQLE_INVALID_LOCAL_OPTION |
SQLState | 08W25 |
ODBC State | 08001 |
An invalid local database switch was found in the DBS option.
Item | Value |
---|---|
SQLCode | -187 |
Constant | SQLE_CURSOROP_NOT_ALLOWED |
SQLState | 09W02 |
ODBC State | 24000 |
An operation that is not allowed was attempted on a cursor.
Item | Value |
---|---|
SQLCode | -200 |
Constant | SQLE_INVALID_OPTION |
SQLState | 42W16 |
ODBC State | 37000 |
Parameter 1 | Name of the invalid option. |
You have probably misspelled the name of an option in the SET OPTION command. You can only define an option for a user if the database administrator has supplied a PUBLIC value for that option.
Item | Value |
---|---|
SQLCode | -95 |
Constant | SQLE_INVALID_PARAMETER |
SQLState | 08W24 |
ODBC State | 08004 |
An error occurred while parsing the string parameter associated with one of the entry points: db_start_engine(), db_start_database(), db_stop_engine(), db_stop_database(), db_string_connect().
Item | Value |
---|---|
SQLCode | -133 |
Constant | SQLE_INVALID_STATEMENT_TYPE |
SQLState | 07W03 |
ODBC State | S1000 |
This is an internal C language interface error. If it occurs, it should be reported to SQL Anywhere technical support.
Item | Value |
---|---|
SQLCode | -272 |
Constant | SQLE_INVALID_TRIGGER_COL_REFS |
SQLState | 52W12 |
ODBC State | 37000 |
The REFERENCES clause in a trigger definition is invalid. An OLD correlation name may have been specified in a BEFORE INSERT trigger, or a NEW correlation name may have been specified in an AFTER DELETE trigger. In both cases, the values do not exist and cannot be referenced.
Item | Value |
---|---|
SQLCode | -201 |
Constant | SQLE_INVALID_OPTION_SETTING |
SQLState | 42W17 |
ODBC State | 37000 |
Parameter 1 | Name of the invalid option. |
You have supplied an invalid value for an option in the SET command. Some options only allow numeric values, while other options only allow the values on and off:evalue..
Item | Value |
---|---|
SQLCode | -405 |
Constant | SQLE_HLI_BAD_CALLBACK |
SQLState | 42W12 |
ODBC State | 42W12 |
WSQL HLI needed to use a callback function, but the function has not been registered using the wsqlregisterfuncs entry point.
Item | Value |
---|---|
SQLCode | -400 |
Constant | SQLE_HLI_BAD_SYNTAX |
SQLState | 42W11 |
ODBC State | 42W11 |
The command string that you sent to wsqlexec cannot be understood. Make sure that all of the keywords in the command string are spelled properly, and that variable names (such as host variable, cursor or statement names) are not too long.
Item | Value |
---|---|
SQLCode | -401 |
Constant | SQLE_HLI_BAD_CURSOR |
SQLState | 34W01 |
ODBC State | 34W01 |
The cursor name indicated in your command is not a valid one. For instance, this error would occur if you tried to close a cursor that had never even been declared.
Item | Value |
---|---|
SQLCode | -403 |
Constant | SQLE_HLI_BAD_HOST_VAR_NAME |
SQLState | 42W09 |
ODBC State | 42W09 |
You have used a host variable, and the host variable callback function does not recognize it.
Item | Value |
---|---|
SQLCode | -404 |
Constant | SQLE_HLI_BAD_HOST_VAR_VALUE |
SQLState | 42W10 |
ODBC State | 42W10 |
You have used a host variable, and the host variable value is too long.
Item | Value |
---|---|
SQLCode | -402 |
Constant | SQLE_HLI_BAD_STATEMENT |
SQLState | 26W01 |
ODBC State | 26W01 |
The statement name indicated in your command is not a valid one. This typically indicates that you have failed to prepare the statement.
Item | Value |
---|---|
SQLCode | -642 |
Constant | SQLE_INVALID_DESCRIPTOR_NAME |
SQLState | 33000 |
ODBC State | 33000 |
You have attempted to deallocate a descriptor which has not been allocated.
Item | Value |
---|---|
SQLCode | -130 |
Constant | SQLE_INVALID_STATEMENT |
SQLState | 07W02 |
ODBC State | S1000 |
The statement identifier (generated by PREPARE) passed to the database for a further operation is invalid.
Item | Value |
---|---|
SQLCode | -608 |
Constant | SQLE_INVALID_TEXTPTR_VALUE |
SQLState | 22W03 |
ODBC State | S1000 |
The value supplied as the TEXTPTR for a WRITETEXT or READTEXT statement is invalid.
Item | Value |
---|---|
SQLCode | -161 |
Constant | SQLE_INVALID_DESCRIBE_TYPE |
SQLState | 07W01 |
ODBC State | (handled by ODBC driver) |
This is an internal C language interface error. If it occurs, it should be reported to SQL Anywhere technical support.
Item | Value |
---|---|
SQLCode | -104 |
Constant | SQLE_INVALID_MODULE_LOGON |
SQLState | 28W01 |
ODBC State | 28000 |
A userid and password were specified when a module was preprocessed but the userid or password is invalid.
Item | Value |
---|---|
SQLCode | -103 |
Constant | SQLE_INVALID_LOGON |
SQLState | 28000 |
ODBC State | 28000 |
The user has supplied an invalid userid or an incorrect password. ISQL will handle this error by presenting a connection dialog to the user.
Item | Value |
---|---|
SQLCode | -209 |
Constant | SQLE_INVALID_COLUMN_VALUE |
SQLState | 23506 |
ODBC State | 23000 |
Parameter 1 | Name of the column that was assigned an invalid value. |
Parameter 2 | Name of the table containing the column. |
An INSERT or UPDATE has specified a value for a column that violates a CHECK constraint, and the INSERT or UPDATE were not done because of the error. Note that a CHECK constraint is violated if it evaluates to FALSE; it is okay if it evaluates to TRUE or UNKNOWN.
Item | Value |
---|---|
SQLCode | -110 |
Constant | SQLE_NAME_NOT_UNIQUE |
SQLState | 52010 |
ODBC State | S0001 |
Parameter 1 | Name of the item that already exists. |
You have tried to create a file, table, view, column, foreign key, or publication with the same name as an existing one.
Item | Value |
---|---|
SQLCode | -262 |
Constant | SQLE_LABEL_NOT_FOUND |
SQLState | 42W24 |
ODBC State | 37000 |
Parameter 1 | Name of the label that could not be found. |
The label referenced in a LEAVE statement was not found.
Item | Value |
---|---|
SQLCode | -135 |
Constant | SQLE_LANGUAGE_EXTENSION |
SQLState | 0AW01 |
ODBC State | S1000 |
The requested operation is valid in some versions of SQL, but not in SQL Anywhere.
Item | Value |
---|---|
SQLCode | 107 |
Constant | SQLE_SYNTAX_EXTENSION_WARNING |
SQLState | 01W07 |
ODBC State | (handled by ODBC driver) |
The command you are executing contains extensions to ANSI 1992 Entry SQL.
Item | Value |
---|---|
SQLCode | -618 |
Constant | SQLE_EXTERNAL_PLATFORM_FAILURE |
SQLState | WW004 |
ODBC State | S1000 |
A call to an external entry point in a dynamically loaded module was qualified by an operating system which was not the operating system on which the engine/server is currently executing.
Item | Value |
---|---|
SQLCode | -124 |
Constant | SQLE_TOO_MANY_COLUMNS_DELETED |
SQLState | 42W44 |
ODBC State | 42000 |
The number of columns in a table can never fall below one. Your ALTER TABLE has more drop/delete column clauses than the current number of columns in the table.
Item | Value |
---|---|
SQLCode | 112 |
Constant | SQLE_MORE_INFO |
SQLState | 01W09 |
ODBC State | (handled by ODBC driver) |
More information is required to complete the request. This is used internally in the database interface library to process a unified logon. It should not be returned to an application.
Item | Value |
---|---|
SQLCode | -139 |
Constant | SQLE_CORRELATION_NAME_AMBIGUOUS |
SQLState | 52012 |
ODBC State | SG001 |
Parameter 1 | Ambiguous correlation name. |
You have identified two tables in the same FROM clause with the same correlation name.
Item | Value |
---|---|
SQLCode | -619 |
Constant | SQLE_REQUIRE_DLL_NAME |
SQLState | WW005 |
ODBC State | S1000 |
The name of the external function to call did not contain a library name specifier.
Item | Value |
---|---|
SQLCode | -197 |
Constant | SQLE_NO_CURRENT_ROW |
SQLState | 24503 |
ODBC State | 24000 |
You have attempted to perform an operation on the current row of a cursor, but there is no current 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.
Item | Value |
---|---|
SQLCode | 100 |
Constant | SQLE_NO_DESCRIPTOR_DATA |
SQLState | 02W01 |
ODBC State | 02W01 |
You have positioned a cursor beyond the beginning or past the end of the query. There is no row at that position. You have attemped to access a descriptor area using an index value larger than the number of variables in the descriptor.
Item | Value |
---|---|
SQLCode | -181 |
Constant | SQLE_NO_INDICATOR |
SQLState | 22002 |
ODBC State | S1000 |
You tried to retrieve a value from the database that was the NULL value but you did not provide an indicator variable for that value.
Item | Value |
---|---|
SQLCode | -194 |
Constant | SQLE_INVALID_FOREIGN_KEY |
SQLState | 23503 |
ODBC State | 23000 |
Parameter 1 | Name of the foreign key. |
Parameter 2 | Name of the table with the foreign key. |
You have tried to insert or update a row that has a foreign key for another table, and the value for the foreign key is not NULL and there is not a corresponding value in the primary key
Item | Value |
---|---|
SQLCode | -211 |
Constant | SQLE_MUST_BE_ONLY_CONNECTION |
SQLState | 42W19 |
ODBC State | 40001 |
You have attempted a data definition language operation that cannot be completed while another is connected.
Item | Value |
---|---|
SQLCode | -101 |
Constant | SQLE_NOT_CONNECTED |
SQLState | 08003 |
ODBC State | 08003 |
You have not connected to the database, or you have executed the DISCONNECT command and have not connected to the database again.
Item | Value |
---|---|
SQLCode | -182 |
Constant | SQLE_SQLDA_TOO_SMALL |
SQLState | 07002 |
ODBC State | 07001 |
There are not enough fields in the SQLDA to retrieve all of the values requested.
Item | Value |
---|---|
SQLCode | -86 |
Constant | SQLE_NO_MEMORY |
SQLState | 08W13 |
ODBC State | S1001 |
The database engine or multiuser client executable was loaded but was unable to start because there is not enough memory to run properly.
Item | Value |
---|---|
SQLCode | -188 |
Constant | SQLE_NOT_ENOUGH_HOST_VARS |
SQLState | 07001 |
ODBC State | 07001 |
You have not provided enough host variables for either the number of bind variables, or the command, or the number of select list items.
Item | Value |
---|---|
SQLCode | 109 |
Constant | SQLE_NULL_VALUE_ELIMINATED |
SQLState | 01003 |
ODBC State | (handled by ODBC driver) |
Value of the expression argument of the aggregate function evaluated to NULL for one or more rows.
Item | Value |
---|---|
SQLCode | -152 |
Constant | SQLE_INVALID_ORDER |
SQLState | 53005 |
ODBC State | 37000 |
You have used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list.
Item | Value |
---|---|
SQLCode | -114 |
Constant | SQLE_VIEW_DEFINITION_ERROR |
SQLState | 53011 |
ODBC State | 21S01 |
An INSERT command contains a SELECT with a different number of columns than the INSERT.
Item | Value |
---|---|
SQLCode | -202 |
Constant | SQLE_NOT_PUBLIC_ID |
SQLState | 42W43 |
ODBC State | 37000 |
Parameter 1 | Name of the option. |
The option specified in the SET OPTION command is PUBLIC only. You cannot define this option for any other user.
Item | Value |
---|---|
SQLCode | -204 |
Constant | SQLE_OPTION_REQUIRES_DBA |
SQLState | 42W46 |
ODBC State | 37000 |
The option specified in the SET OPTION command can only be set by a user having DBA authority.
Item | Value |
---|---|
SQLCode | -122 |
Constant | SQLE_GROUP_CYCLE |
SQLState | 42W02 |
ODBC State | 37000 |
You have tried to add a member to group that would result in a member belonging to itself (perhaps indirectly).
Item | Value |
---|---|
SQLCode | -615 |
Constant | SQLE_INVALID_PARAMETER_NAME |
SQLState | 42W47 |
ODBC State | 37000 |
The procedure parameter name does not match a parameter for this procedure. Check the spelling of the parameter name.
Item | Value |
---|---|
SQLCode | -639 |
Constant | SQLE_PARAMETER_NAME_MISSING |
SQLState | 42W42 |
ODBC State | 37000 |
Parameter 1 | The name of the procedure |
Positional arguments were specified after keyword arguments in a call to this procedure.
Item | Value |
---|---|
SQLCode | -287 |
Constant | SQLE_PASSTHROUGH_INCONSISTENT |
SQLState | 5RW08 |
ODBC State | S0002 |
Passthrough is additive, in that subsequent passthrough statements add to the list of users receiving passthrough. The passthrough statements must all be PASSTHROUGH ONLY or none should be PASSTHROUGH ONLY.
Item | Value |
---|---|
SQLCode | -119 |
Constant | SQLE_PRIMARY_KEY_COLUMN_DEFINED |
SQLState | 52009 |
ODBC State | 23000 |
Parameter 1 | Name of the column that is already in the primary key. |
You have listed the same column name twice in the definition of a primary key.
Item | Value |
---|---|
SQLCode | -198 |
Constant | SQLE_PRIMARY_KEY_VALUE_REF |
SQLState | 23W05 |
ODBC State | 23000 |
Parameter 1 | The name of the table with a primary key that is referenced. |
You have attempted to delete or modify a primary key that is referenced elsewhere in the database.
Item | Value |
---|---|
SQLCode | -193 |
Constant | SQLE_PRIMARY_KEY_NOT_UNIQUE |
SQLState | 23W01 |
ODBC State | 23000 |
Parameter 1 | Name of the table where the problem was detected. |
You have tried to add a new row to a table where 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.
Item | Value |
---|---|
SQLCode | -265 |
Constant | SQLE_PROCEDURE_NOT_FOUND |
SQLState | 52W09 |
ODBC State | S0002 |
Parameter 1 | Name of the procedure that could not be found. |
You have misspelled the name of a procedure, or you have connected with a different userid and forgotten to qualify a procedure name with a user name.
Item | Value |
---|---|
SQLCode | 105 |
Constant | SQLE_PROCEDURE_COMPLETE |
SQLState | 01W05 |
ODBC State | (handled by ODBC driver) |
An OPEN or a RESUME has caused a procedure to execute to completion. There are no more result sets available from this procedure. This warning will also be returned if you attempt to RESUME a cursor on a SELECT statement.
Item | Value |
---|---|
SQLCode | -215 |
Constant | SQLE_PROCEDURE_IN_USE |
SQLState | 42W23 |
ODBC State | 40001 |
You have attempted to DROP a procedure that is being used by other active users of the database.
Item | Value |
---|---|
SQLCode | -274 |
Constant | SQLE_NESTING_TOO_DEEP |
SQLState | 42W29 |
ODBC State | 37000 |
You have probably defined a procedure or trigger that causes unlimited recursion.
Item | Value |
---|---|
SQLCode | -280 |
Constant | SQLE_PUBLICATION_NOT_FOUND |
SQLState | 5RW01 |
ODBC State | S0002 |
Parameter 1 | Name of the publication that could not be found. |
You have misspelled the name of a publication, or you have connected with a different userid and forgotten to qualify a publication name with a user name.
Item | Value |
---|---|
SQLCode | -631 |
Constant | SQLE_RAISERROR_STMT |
SQLState | WW012 |
ODBC State | S1000 |
Parameter 1 | RAISERROR message string |
A RAISERROR statement has been executed.
Item | Value |
---|---|
SQLCode | -286 |
Constant | SQLE_NOT_REMOTE_TYPE |
SQLState | 5RW07 |
ODBC State | S0002 |
Parameter 1 | Name of remote message type. |
You have refered to a remote message type that is not defined in this database. CREATE REMOTE TYPE is used to define remote message types.
Item | Value |
---|---|
SQLCode | -288 |
Constant | SQLE_REMOTE_STATEMENT_FAILED |
SQLState | 5RW09 |
ODBC State | S0002 |
This SQLSTATE can be signalled within a trigger to prevent DBREMOTE from from displaying an error message in the output. This exception will only occur when a trigger or procedure SIGNALS it. This is useful for ignoring replication errors that are permitted by design.
Item | Value |
---|---|
SQLCode | -76 |
Constant | SQLE_REQUEST_DENIED_NO_DATABASES |
SQLState | 08W28 |
ODBC State | 08001 |
The engine has denied the request as there are currently no loaded databases.
Item | Value |
---|---|
SQLCode | -75 |
Constant | SQLE_START_STOP_DATABASE_DENIED |
SQLState | 08W29 |
ODBC State | 08001 |
The engine has denied permission to start/stop a database.
Item | Value |
---|---|
SQLCode | -222 |
Constant | SQLE_RESULT_NOT_ALLOWED |
SQLState | 3BW02 |
ODBC State | S1000 |
A SELECT statement with no INTO clause or a RESULT CURSOR statement are not allowed within an atomic compound statement.
Item | Value |
---|---|
SQLCode | -638 |
Constant | SQLE_STRING_RIGHT_TRUNCATION |
SQLState | 22001 |
ODBC State | 22001 |
Non-space characters were truncated upon the assignment of string data.
Item | Value |
---|---|
SQLCode | -221 |
Constant | SQLE_ROLLBACK_NOT_ALLOWED |
SQLState | 3B002 |
ODBC State | S1000 |
A ROLLBACK TO SAVEPOINT within an atomic operation is not allowed to a savepoint established before the atomic operation.
Item | Value |
---|---|
SQLCode | 104 |
Constant | SQLE_ROW_UPDATED_WARNING |
SQLState | 01W04 |
ODBC State | (handled by ODBC driver) |
A FETCH has retrieved a row from a cursor declared as a SCROLL cursor, and the row was previously fetched from the same cursor, and one or more columns in the row has been updated since the previous fetch. Note that the column(s) updated may or may not be fetched by the cursor; this warning just indicates that the row from the table has been updated. If the cursor involves more than one table, a row from one or more of the tables has been updated.
Item | Value |
---|---|
SQLCode | -208 |
Constant | SQLE_ROW_UPDATED_SINCE_READ |
SQLState | 22W02 |
ODBC State | (handled by ODBC driver) |
You have done a UPDATE (positioned) or DELETE (positioned) on a cursor declared as a SCROLL cursor, and the row you are changing has been updated since you read it. This prevents the 'lost update' problem.
Item | Value |
---|---|
SQLCode | -300 |
Constant | SQLE_ERROR |
SQLState | 40000 |
ODBC State | S1000 |
Parameter 1 | Identification of the error. |
This error indicates an internal database error, and should be reported to SQL Anywhere technical support.
Item | Value |
---|---|
SQLCode | -220 |
Constant | SQLE_SAVEPOINT_NOTFOUND |
SQLState | 3B001 |
ODBC State | S1000 |
Parameter 1 | Name of savepoint. |
You attempted to rollback to a savepoint that does not exist.
Item | Value |
---|---|
SQLCode | -213 |
Constant | SQLE_SAVEPOINTS_REQUIRE_UNDO |
SQLState | 3BW01 |
ODBC State | S1000 |
You cannot use savepoints when the database engine is running in bulk mode without a rollback log.
Item | Value |
---|---|
SQLCode | -153 |
Constant | SQLE_INVALID_UNION |
SQLState | 53026 |
ODBC State | 37000 |
You have specified a UNION but the SELECT statements involved in the union do not have the same number of columns in the select list.
Item | Value |
---|---|
SQLCode | -185 |
Constant | SQLE_TOO_MANY_RECORDS |
SQLState | 21000 |
ODBC State | S1000 |
An Embedded SELECT statement that does not use a cursor returns more than one result.
Item | Value |
---|---|
SQLCode | -232 |
Constant | SQLE_SERVER_ENGINE_MISMATCH |
SQLState | 08W20 |
ODBC State | 08001 |
Your version of the database server software is not compatible with your version of the database engine.
Item | Value |
---|---|
SQLCode | -84 |
Constant | SQLE_INVALID_DATABASE |
SQLState | 08W11 |
ODBC State | 08001 |
The database engine was started but the specified database file is invalid. The engine is stopped.
Item | Value |
---|---|
SQLCode | -83 |
Constant | SQLE_DATABASE_NOT_FOUND |
SQLState | 08W10 |
ODBC State | 08001 |
The database engine or multiuser client was started but was unable to find the specified database or server name. The database file cannot be opened or the specified server cannot be found on the network. The database engine or client is stopped.
Item | Value |
---|---|
SQLCode | -406 |
Constant | SQLE_HLI_INTERNAL |
SQLState | WI007 |
ODBC State | WI007 |
This is a SQL Anywhere internal error and should be reported to Watcom.
Item | Value |
---|---|
SQLCode | -132 |
Constant | SQLE_STATEMENT_ERROR |
SQLState | 26501 |
ODBC State | S1000 |
The statement identifier (generated by PREPARE) passed to the database for a further operation is invalid.
Item | Value |
---|---|
SQLCode | -230 |
Constant | SQLE_PP_DBLIB_MISMATCH |
SQLState | 08W18 |
ODBC State | 08001 |
Your executable has source files with Embedded SQL that were preprocessed with a preprocessor that does not match the database interface library.
Item | Value |
---|---|
SQLCode | -206 |
Constant | SQLE_INVALID_INTEGRATED_LOGON |
SQLState | 28W03 |
ODBC State | 28000 |
The engine logon type switch (gl) is set to INTEGRATED logon type, and the user has attempted a standard logon.
Item | Value |
---|---|
SQLCode | 111 |
Constant | SQLE_CANNOT_EXECUTE_STMT |
SQLState | 01W08 |
ODBC State | (handled by ODBC driver) |
You have specified a statement for the PREPARE..WITH EXECUTE statement that cannot be executed. If you specified an output SQLDA, it may contain a DESCRIBE of the prepared statement.
Item | Value |
---|---|
SQLCode | -299 |
Constant | SQLE_INTERRUPTED |
SQLState | 57014 |
ODBC State | S1000 |
The user has aborted a statement during its execution. The database was able to stop the operation without doing a rollback. If the statement is INSERT, UPDATE, or DELETE, any changes made by the statement will be cancelled. If the statement is a data definition command (for example CREATE TABLE), the command will be cancelled, but the COMMIT that was done as a side effect will not be cancelled.
Item | Value |
---|---|
SQLCode | -151 |
Constant | SQLE_SUBQUERY_SELECT_LIST |
SQLState | 53023 |
ODBC State | 37000 |
You have entered a subquery which has more than one column in the select list. Change the select list to have only one column.
Item | Value |
---|---|
SQLCode | -186 |
Constant | SQLE_SUBQUERY_RESULT_NOT_UNIQUE |
SQLState | 21W01 |
ODBC State | 37000 |
The result of a subquery contains more than one row. If the subquery is in the WHERE clause, you might be able to use IN.
Item | Value |
---|---|
SQLCode | -282 |
Constant | SQLE_SUBSCRIPTION_NOT_UNIQUE |
SQLState | 5RW03 |
ODBC State | S0002 |
Parameter 1 | Name of the publication. |
Parameter 2 | Name of the user. |
You have tried to create a subscription that already exists.
Item | Value |
---|---|
SQLCode | -283 |
Constant | SQLE_SUBSCRIPTION_NOT_FOUND |
SQLState | 5RW04 |
ODBC State | S0002 |
Parameter 1 | Name of the publication. |
Parameter 2 | Name of the user. |
You have tried to drop, start, or synchronize a subscription that does not exist.
Item | Value |
---|---|
SQLCode | -131 |
Constant | SQLE_SYNTAX_ERROR |
SQLState | 42W04 |
ODBC State | 37000 |
Parameter 1 | The word or symbol where the syntax error has been detected. |
The database engine cannot understand the command you are trying to execute. If you have used a keyword (such as DATE) for a column name, try enclosing the keyword in quotation marks ("DATE").
Item | Value |
---|---|
SQLCode | -118 |
Constant | SQLE_NO_PRIMARY_KEY |
SQLState | 55008 |
ODBC State | 23000 |
Parameter 1 | Name of the table that does not have a primary key. |
You have attempted to add a foreign key referring to a table that does not have a primary key. You will need to add a primary key to the named table.
Item | Value |
---|---|
SQLCode | -281 |
Constant | SQLE_TABLE_HAS_PUBLICATIONS |
SQLState | 5RW02 |
ODBC State | S0002 |
Parameter 1 | Name of the publication that has publications. |
You have attempted to drop a table that has publications defined.
Item | Value |
---|---|
SQLCode | -136 |
Constant | SQLE_OUTER_JOIN_CYCLE |
SQLState | 52W14 |
ODBC State | 37000 |
Parameter 1 | Name of a table in the cycle. |
You have specified outer joins that create a cycle of tables.
Item | Value |
---|---|
SQLCode | -141 |
Constant | SQLE_TABLE_NOT_FOUND |
SQLState | 42W33 |
ODBC State | 42000 |
Parameter 1 | Name of the table that could not be found. |
You have misspelled the name of a table, or you have connected with a different user ID and forgotten to qualify a table name with a user name. For example, you might have referred to employee instead of "DBA".employee,
Item | Value |
---|---|
SQLCode | -137 |
Constant | SQLE_CORRELATION_NAME_NEEDED |
SQLState | 52W15 |
ODBC State | 37000 |
Parameter 1 | Name of the table that needs a unique correlation name. |
You have specified a join that joins a table to itself. You need to use unique correlation names in order to have multiple instances of a table.
Item | Value |
---|---|
SQLCode | -112 |
Constant | SQLE_EXISTING_PRIMARY_KEY |
SQLState | 55013 |
ODBC State | 23000 |
You have tried to add a primary key on a table that already has a primary key defined. You must delete the current primary key before adding a new one.
Item | Value |
---|---|
SQLCode | -126 |
Constant | SQLE_PRIMARY_KEY_TWICE |
SQLState | 52W05 |
ODBC State | 23000 |
You have specified the primary key twice in a CREATE TABLE command.
Item | Value |
---|---|
SQLCode | -214 |
Constant | SQLE_TABLE_IN_USE |
SQLState | 42W21 |
ODBC State | 40001 |
You have attempted to ALTER or DROP a table that is being used by other active users of the database.
Item | Value |
---|---|
SQLCode | -116 |
Constant | SQLE_TABLE_MUST_BE_EMPTY |
SQLState | 55W02 |
ODBC State | S1000 |
You have attempted to modify a table, and SQL Anywhere can only perform the change if there are no rows in the table.
Item | Value |
---|---|
SQLCode | -302 |
Constant | SQLE_TERMINATED_BY_USER |
SQLState | 40W02 |
ODBC State | S1000 |
The user has aborted a command while the database was executing. A ROLLBACK WORK command has been automatically executed. This will happen when the engine is running in bulk mode and the user aborts an INSERT, UPDATE, or DELETE operation.
Item | Value |
---|---|
SQLCode | -247 |
Constant | SQLE_INTEGRATED_LOGON_GUESTMAP |
SQLState | 28W06 |
ODBC State | 28000 |
The dba attempted to map guest loginID to something other than guest
Item | Value |
---|---|
SQLCode | -313 |
Constant | SQLE_INTEGRATED_LOGON_UNMAPPED |
SQLState | 28W09 |
ODBC State | 28000 |
The dba attempted to drop a loginID that had not been mapped yet
Item | Value |
---|---|
SQLCode | -249 |
Constant | SQLE_INTEGRATED_LOGON_MAPPED |
SQLState | 28W08 |
ODBC State | 28000 |
The dba attempted to map a loginID twice
Item | Value |
---|---|
SQLCode | -74 |
Constant | SQLE_DATABASE_NOT_ACTIVE |
SQLState | 08W30 |
ODBC State | 08001 |
The selected database is in an inactive state. This state occurs during database initialization and shutdown.
Item | Value |
---|---|
SQLCode | 400 |
Constant | SQLE_HLI_MORE_DATA_AVAILABLE |
SQLState | 01WH1 |
ODBC State | (handled by ODBC driver) |
You attempted to get a query result set using the WSQL HLI function wsqlquerytomem. The buffer supplied by the calling application was too small to contain the entire query. The buffer will contain as many rows of the result set as possible, and the cursor will be positioned on the next row of the result set.
Item | Value |
---|---|
SQLCode | -109 |
Constant | SQLE_STILL_ACTIVE_CONNECTIONS |
SQLState | 08W06 |
ODBC State | S1000 |
An application has requested SQL Anywhere to shutdown the database using the db_stop() function when there are still active connections to the database.
Item | Value |
---|---|
SQLCode | -261 |
Constant | SQLE_VARIABLE_EXISTS |
SQLState | 42W15 |
ODBC State | 37000 |
You have tried to CREATE a variable with the name of another variable that already exists.
Item | Value |
---|---|
SQLCode | -147 |
Constant | SQLE_AMBIGUOUS_JOIN |
SQLState | 52W08 |
ODBC State | 37000 |
Parameter 1 | Name of first table that cannot be joined. |
Parameter 2 | Name of second table that cannot be joined. |
There are two or more foreign keys relating the two tables and you are attempting to KEY JOIN the two tables. Either there are two foreign keys from the first table to the second table, or each table has a foreign key to the other table. You must use a correlation name for the primary key table which is the same as the role name of the desired foreign key relationship.
Item | Value |
---|---|
SQLCode | -146 |
Constant | SQLE_CANNOT_JOIN |
SQLState | 53W04 |
ODBC State | 37000 |
Parameter 1 | Name of first table that cannot be joined. |
Parameter 2 | Name of second table that cannot be joined. |
You have attempted a KEY JOIN between two tables and there is no foreign key on one of the tables that references the primary key of the other table; or you have attempted a NATURAL JOIN between two tables and the tables have no common column names.
Item | Value |
---|---|
SQLCode | -616 |
Constant | SQLE_TOO_MANY_COLUMNS_IN_TABLE |
SQLState | 52W20 |
ODBC State | S1000 |
A CREATE TABLE or ALTER TABLE statement attempted to add a column to a table, but the resulting number of columns in the table would exceed the limit for the current database page size.
Item | Value |
---|---|
SQLCode | -102 |
Constant | SQLE_TOO_MANY_CONNECTIONS |
SQLState | 08W03 |
ODBC State | 08004 |
If you are running the multiuser client, you have exceeded the number of computers allowed to connect to the server by your license agreement. Otherwise, the single user DOS engine is limited to 2 connections, and the Windows engine is restricted to 10 connections.
Item | Value |
---|---|
SQLCode | -625 |
Constant | SQLE_TOO_MANY_PARAMETERS |
SQLState | WW010 |
ODBC State | S1000 |
This is a Windows 32-bit specific error. There is a maximum of 256 parameters to an external function call.
Item | Value |
---|---|
SQLCode | -611 |
Constant | SQLE_TSQL_FEATURE_NOT_SUPPORTED |
SQLState | 0AW02 |
ODBC State | 37000 |
An attempt was made to use a feature of Transact-SQL that is not supported.
Item | Value |
---|---|
SQLCode | 110 |
Constant | SQLE_BACKUP_PAGE_INCOMPLETE |
SQLState | 01W10 |
ODBC State | (handled by ODBC driver) |
A DB_LOG_BACKUP_READ_WAIT was issued against the transaction log and the page returned was not full. The application should reissue the request for the same page.
Item | Value |
---|---|
SQLCode | -244 |
Constant | SQLE_LOG_TRUNCATED |
SQLState | WB005 |
ODBC State | S1000 |
An operation was being performed on the transaction log such as SQL Remote or Replication Agent processing and the transaction log was truncated by an independant backup during that operation.
Item | Value |
---|---|
SQLCode | -268 |
Constant | SQLE_TRIGGER_NOT_FOUND |
SQLState | 52W10 |
ODBC State | S0002 |
Parameter 1 | Name of the trigger that could not be found. |
You have misspelled the name of a trigger, or you have connected with a different userid and forgotten to qualify a trigger name with a user name.
Item | Value |
---|---|
SQLCode | -271 |
Constant | SQLE_TRIGGER_DEFN_CONFLICT |
SQLState | 52W11 |
ODBC State | S0001 |
A trigger definition could not be created because it conflicts with an existing trigger definition. A trigger with the same name may already exist.
Item | Value |
---|---|
SQLCode | -275 |
Constant | SQLE_PROCEDURES_NOT_IN_DESKTOP |
SQLState | 0AW04 |
ODBC State | S1000 |
You have attempted to call a stored procedure or have modified a row in a table on which a trigger is defined and you are using the desktop engine. Triggers and stored procedures are not supported in the runtime engine. You must be running the full engine to use these features.
Item | Value |
---|---|
SQLCode | -243 |
Constant | SQLE_BACKUP_UNABLE_TO_DELETE_FILE |
SQLState | WB004 |
ODBC State | S1000 |
The specified file could not be deleted. The filename should not be the same as any database file that is currently in use.
Item | Value |
---|---|
SQLCode | -189 |
Constant | SQLE_NOT_FOUND_IN_INDEX |
SQLState | WI005 |
ODBC State | S1000 |
Parameter 1 | Name of invalid index. |
Parameter 2 | Name of table containing the invalid index. |
This is a SQL Anywhere internal error and should be reported to SQL Anywhere technical support. You should be able to work around the error by dropping and recreating the index.
Item | Value |
---|---|
SQLCode | -80 |
Constant | SQLE_UNABLE_TO_START_ENGINE |
SQLState | 08W07 |
ODBC State | 08001 |
It was not possible to start the database engine or multiuser client. Either there is not enough memory to run the database engine, or the executable cannot be found.
Item | Value |
---|---|
SQLCode | -82 |
Constant | SQLE_UNABLE_TO_START_DATABASE |
SQLState | 08W09 |
ODBC State | 08001 |
The database engine or multiuser client was started but was unable to find the specified database or server name. No specific reason is known.
Item | Value |
---|---|
SQLCode | -240 |
Constant | SQLE_UNKNOWN_BACKUP_OPERATION |
SQLState | WB001 |
ODBC State | S1000 |
An invalid backup command operation was specified in a call to db_backup.
Item | Value |
---|---|
SQLCode | -148 |
Constant | SQLE_UNKNOWN_FUNC |
SQLState | 42W05 |
ODBC State | 37000 |
Parameter 1 | Function name that is not a database function. |
You have misspelled the name of a database function (such as MAXIMUM instead of MAX) in a query definition or in a query column name.
Item | Value |
---|---|
SQLCode | -634 |
Constant | SQLE_UNTERMINATED_C_STR |
SQLState | 22024 |
ODBC State | 22024 |
The least significant character of a C string host variable must contain the null character.
Item | Value |
---|---|
SQLCode | -633 |
Constant | SQLE_READ_ONLY_CURSOR |
SQLState | 42W30 |
ODBC State | 42030 |
An update operation has been attempted on a cursor that was explicitly declared as read-only.
Item | Value |
---|---|
SQLCode | -192 |
Constant | SQLE_NON_UPDATEABLE_VIEW |
SQLState | 42W31 |
ODBC State | 42031 |
You have attempted an insert, update, or delete operation on a query that is implictly read-only. An updatable query may not contain DISTINCT, GROUP BY, HAVING, or UNION, nor may it contain aggregate functions or involve a join. If the query references a view then the query expression that defines the view must itself be updatable.
Item | Value |
---|---|
SQLCode | -120 |
Constant | SQLE_ALREADY_HAS_GRANT_PERMS |
SQLState | 42W01 |
ODBC State | 37000 |
Parameter 1 | Name of the userid that already has GRANT permission. |
The SQL GRANT command is attempting to give a user GRANT OPTION and that user already has GRANT OPTION.
Item | Value |
---|---|
SQLCode | -312 |
Constant | SQLE_ALREADY_HAS_GROUP_MEMBERSHIP |
SQLState | 42W34 |
ODBC State | 37000 |
Parameter 1 | Name of the userid that already has membership. |
Parameter 2 | Name of the group. |
The SQL GRANT command is attempting to give a membership in a group to user that already has such membership.
Item | Value |
---|---|
SQLCode | -210 |
Constant | SQLE_LOCKED |
SQLState | 42W18 |
ODBC State | 40001 |
Parameter 1 | Name of another user. |
Parameter 2 | Table which generates the error. |
You have attempted to read or write a row and it is locked by another user. Note that this error will only be received if the database option BLOCKING is set to OFF. Otherwise, the requesting transaction will block until the row lock is released.
Item | Value |
---|---|
SQLCode | -284 |
Constant | SQLE_ONLY_ONE_PUBLISHER |
SQLState | 5RW05 |
ODBC State | S0002 |
Parameter 1 | Name of the publisher. |
You have tried to GRANT PUBLISH to a userid, when a publisher already exists.
Item | Value |
---|---|
SQLCode | -285 |
Constant | SQLE_NOT_REMOTE_USER |
SQLState | 5RW06 |
ODBC State | S0002 |
Parameter 1 | Name of user. |
You have tried to CREATE a subscription for a user, or PASSTHROUGH for a user that is not a remote user of this database. You must GRANT REMOTE or GRANT CONSOLIDATE.
Item | Value |
---|---|
SQLCode | -123 |
Constant | SQLE_NOT_A_GROUP |
SQLState | 42W03 |
ODBC State | 37000 |
Parameter 1 | Name of user you thought was a group. |
You have tried to add a member to group, but the group specified has not been granted the GROUP special privilege.
Item | Value |
---|---|
SQLCode | -610 |
Constant | SQLE_MESSAGE_ALREADY_EXISTS |
SQLState | 52W16 |
ODBC State | 23000 |
The message with this error number already exists in SYSUSERMESSAGES.
Item | Value |
---|---|
SQLCode | -612 |
Constant | SQLE_MESSAGE_NOT_FOUND |
SQLState | 52W17 |
ODBC State | S0002 |
Parameter 1 | Message number. |
The message with this error number does not exist in SYSUSERMESSAGES.
Item | Value |
---|---|
SQLCode | -297 |
Constant | SQLE_USER_DEFINED_EXCEPTION |
SQLState | 99999 |
ODBC State | S1000 |
A stored procedure or trigger signalled a user-defined exception. This error state is reserved for use within stored procedures or triggers which contain exception handlers, as a way of signalling an exception which can be guaranteed to not have been caused by the database engine.
Item | Value |
---|---|
SQLCode | -613 |
Constant | SQLE_USER_TYPE_NOT_FOUND |
SQLState | 52W18 |
ODBC State | S0002 |
Parameter 1 | Name of the user-defined type. |
The user-defined type with this name does not exist in SYSUSERTYPE.
Item | Value |
---|---|
SQLCode | -140 |
Constant | SQLE_UNKNOWN_USERID |
SQLState | 08004 |
ODBC State | 28000 |
Parameter 1 | Name of the userid that could not be found. |
The specified userid does not exist.
Item | Value |
---|---|
SQLCode | 102 |
Constant | SQLE_TEMPORARY_TABLE |
SQLState | 01W02 |
ODBC State | (handled by ODBC driver) |
A temporary table has been created in order to satisfy the query. It can only occur on an OPEN statement.
Item | Value |
---|---|
SQLCode | -158 |
Constant | SQLE_OVERFLOW_ERROR |
SQLState | 22003 |
ODBC State | 22003 |
Parameter 1 | The value that caused the overflow. |
A value has been supplied to the database or retrieved from the database that is out of range for the destination column or host variable. For example, the value 10 may have been supplied for a DECIMAL(3,2) field.
Item | Value |
---|---|
SQLCode | 106 |
Constant | SQLE_COLUMN_VALUE_CHANGED |
SQLState | 01W06 |
ODBC State | (handled by ODBC driver) |
Parameter 1 | Name of the column whose value has changed. |
Parameter 2 | Name of the table containing the column. |
A replicated UPDATE has found a value in an updated column that does not match the value when the original UPDATE was made.
Item | Value |
---|---|
SQLCode | 101 |
Constant | SQLE_TRUNCATED |
SQLState | 01004 |
ODBC State | 01004 |
You have tried to insert, update, or select a value in the database which is too large to fit in the destination. This warning is also produced if you do a fetch, and the host variable or SQLDA variable is not large enough to receive the value.
Item | Value |
---|---|
SQLCode | -260 |
Constant | SQLE_VARIABLE_NOT_FOUND |
SQLState | 42W14 |
ODBC State | 37000 |
You have tried to DROP or SET the value of a SQL variable that was not created or was previously dropped.
Item | Value |
---|---|
SQLCode | 200 |
Constant | SQLE_WARNING |
SQLState | 01000 |
ODBC State | (handled by ODBC driver) |
A warning has occurred. The warning message will indicate the condition that caused the warning.
Item | Value |
---|---|
SQLCode | -632 |
Constant | SQLE_WITH_CHECK_OPTION_VIOLATION |
SQLState | 44000 |
ODBC State | 44000 |
Parameter 1 | View where check option violated |
A value in the row(s) being inserted or modified fell outside the range of the view
Item | Value |
---|---|
SQLCode | -154 |
Constant | SQLE_WRONG_PARAMETER_COUNT |
SQLState | 37505 |
ODBC State | 37000 |
Parameter 1 | Name of the function. |
You have supplied an incorrect number of parameters to a database function.
Item | Value |
---|---|
SQLCode | -207 |
Constant | SQLE_WRONG_NUM_OF_INSERT_COLS |
SQLState | 53002 |
ODBC State | 37000 |
The number of values you are trying to insert does not match the number of columns specified in the INSERT command, or the number of columns in the table if no columns are specified.
Item | Value |
---|---|
SQLCode | -264 |
Constant | SQLE_WRONG_NUM_OF_FETCH_VARIABLES |
SQLState | 42W26 |
ODBC State | 37000 |
The number of variables specified in the FETCH statement does not match the number of select list items.