| SQLSTATE |
Message |
|
| 00000 |
(no message) |
|
| 01000 |
Warning |
|
| 01001 |
Cursor operation conflict |
|
| 01003 |
Null value eliminated in aggregate function |
|
| 01004 |
Value truncated |
|
| 01W02 |
Using temporary table |
|
| 01W03 |
Invalid data conversion |
|
| 01W04 |
Row has been updated since last time read |
|
| 01W05 |
Procedure has completed |
|
| 01W06 |
Value for column '%1' in table '%2' has changed |
|
| 01W07 |
Language extension detected in syntax |
|
| 01W08 |
Statement cannot be executed |
|
| 01W09 |
More info required |
|
| 01W10 |
Transaction log backup page only partially full |
|
| 01W11 |
Database option '%1' for user '%2' has an invalid setting |
|
| 01WH1 |
The supplied buffer was too small to hold all requested query results |
|
| 02W01 |
No data |
|
| 07001 |
Not enough values for host variables |
|
| 07002 |
Not enough fields allocated in SQLDA |
|
| 07003 |
Error opening cursor |
|
| 07005 |
Can only describe a SELECT statement |
|
| 07009 |
Invalid descriptor index |
|
| 07W01 |
Invalid type on DESCRIBE statement |
|
| 07W02 |
Invalid statement |
|
| 07W03 |
Invalid prepared statement type |
|
| 08001 |
Cannot be started -- %1 |
|
| 08003 |
Not connected to SQL database |
|
| 08004 |
Userid '%1' does not exist |
|
| 08W01 |
Database engine not running |
|
| 08W02 |
Connection not found |
|
| 08W03 |
Too many connections to database |
|
| 08W04 |
Connections to database have been disabled |
|
| 08W05 |
Cannot open log file %1 |
|
| 08W06 |
There are still active database connections |
|
| 08W07 |
Unable to start database engine |
|
| 08W08 |
Invalid database engine command line |
|
| 08W09 |
Unable to start specified database |
|
| 08W10 |
Specified database not found |
|
| 08W11 |
Specified database is invalid |
|
| 08W12 |
Communication error |
|
| 08W13 |
Not enough memory to start |
|
| 08W14 |
Database name required to start engine |
|
| 08W15 |
Client/server communications protocol mismatch |
|
| 08W16 |
Database engine not running in multiuser mode |
|
| 08W17 |
Error writing to log file |
|
| 08W18 |
Sqlpp/dblib version mismatch |
|
| 08W19 |
Dblib/database engine version mismatch |
|
| 08W20 |
Server/database engine version mismatch |
|
| 08W21 |
Authentication violation |
|
| 08W22 |
Database's page size too big |
|
| 08W23 |
Database engine already running |
|
| 08W24 |
Invalid parameter |
|
| 08W25 |
Invalid local database switch |
|
| 08W26 |
Dynamic memory exhausted! |
|
| 08W27 |
Database name not unique |
|
| 08W28 |
Request denied -- no active databases |
|
| 08W29 |
Request to start/stop database denied |
|
| 08W30 |
The selected database is currently inactive |
|
| 08W31 |
Communication buffer underflow |
|
| 08W32 |
Invalid database page size |
|
| 08W33 |
Database creation failed |
|
| 09W01 |
Error inserting into cursor |
|
| 09W02 |
Invalid operation for this cursor |
|
| 09W04 |
INSERT/DELETE on cursor can modify only one table |
|
| 09W05 |
Cannot uniquely identify rows in cursor |
|
| 0A000 |
Feature '%1' not implemented |
|
| 0AW01 |
Language extension |
|
| 0AW02 |
Transact-SQL feature not supported |
|
| 0AW03 |
Disallowed language extension detected in syntax near '%1' |
|
| 0AW04 |
Triggers and procedures not supported in runtime engine |
|
| 21000 |
SELECT returns more than one row |
|
| 21W01 |
Subquery cannot return more than one result |
|
| 22001 |
Right truncation of string data |
|
| 22002 |
No indicator variable provided for NULL result |
|
| 22003 |
Value %1 out of range for destination |
|
| 22005 |
Error in assignment |
|
| 22012 |
Division by zero |
|
| 22019 |
Invalid escape character '%1' |
|
| 22024 |
Unterminated C string |
|
| 22025 |
Invalid escape sequence '%1' |
|
| 22W01 |
An argument passed to a SQL Anywhere HLI function was invalid |
|
| 22W02 |
Row has changed since last read -- operation cancelled |
|
| 22W03 |
Invalid TEXTPTR value used with WRITETEXT or READTEXT |
|
| 23502 |
Column '%1' in table '%2' cannot be NULL |
|
| 23503 |
No primary key value for foreign key '%1' in table '%2' |
|
| 23505 |
Index '%1' for table '%2' would not be unique |
|
| 23506 |
Invalid value for column '%1' in table '%2' |
|
| 23W01 |
Primary key for table '%1' is not unique |
|
| 23W05 |
Primary key for row in table '%1' is referenced in another table |
|
| 24501 |
Cursor not open |
|
| 24502 |
Cursor already open |
|
| 24503 |
No current row of cursor |
|
| 24W01 |
Cursor has not been declared |
|
| 26501 |
SQL statement error |
|
| 26W01 |
Invalid SQL Anywhere HLI statement name |
|
| 28000 |
Invalid userid or password |
|
| 28W01 |
Invalid userid and password on preprocessed module |
|
| 28W02 |
Integrated logons are not permitted |
|
| 28W03 |
Standard logons are not permitted |
|
| 28W04 |
Integrated logon failed |
|
| 28W05 |
Integrated logons are not supported for this database |
|
| 28W06 |
The integrated loginid guest can only be mapped to the guest database userid |
|
| 28W07 |
Cannot map a loginid to the sys or public userid |
|
| 28W08 |
The loginid '%1' is already mapped to userid '%2' |
|
| 28W09 |
The loginid '%1' has not been mapped to any database userid |
|
| 2D501 |
COMMIT/ROLLBACK not allowed within trigger actions |
|
| 33000 |
Invalid SQL descriptor name |
|
| 34W01 |
Invalid SQL Anywhere HLI cursor name |
|
| 37505 |
Wrong number of parameters to function '%1' |
|
| 3B001 |
Savepoint '%1' not found |
|
| 3B002 |
ROLLBACK TO SAVEPOINT not allowed |
|
| 3BW01 |
Savepoints require a rollback log |
|
| 3BW02 |
Result set not allowed from within an atomic compound statement |
|
| 40000 |
Run time SQL error -- %1 |
|
| 40001 |
Deadlock detected |
|
| 40W01 |
Internal database error %1 -- transaction rolled back |
|
| 40W02 |
Terminated by user -- transaction rolled back |
|
| 40W03 |
Disk full '%1' -- transaction rolled back |
|
| 40W04 |
I/O error %1 -- transaction rolled back |
|
| 40W06 |
All threads are blocked |
|
| 40W07 |
Connection was terminated |
|
| 42501 |
Do not have permission to %1 |
|
| 42W01 |
User '%1' already has grant permission |
|
| 42W02 |
Operation would cause a group cycle |
|
| 42W03 |
User '%1' is not a user group |
|
| 42W04 |
Syntax error near '%1' |
|
| 42W05 |
Unknown function '%1' |
|
| 42W06 |
Aggregate functions not allowed on this statement |
|
| 42W07 |
Invalid host variable |
|
| 42W08 |
Invalid expression near '%1' |
|
| 42W09 |
Invalid SQL Anywhere HLI host variable name |
|
| 42W10 |
Invalid SQL Anywhere HLI host variable value |
|
| 42W11 |
Invalid SQL Anywhere HLI command syntax |
|
| 42W12 |
Invalid SQL Anywhere HLI callback function |
|
| 42W13 |
Invalid column number |
|
| 42W14 |
Variable '%1' not found |
|
| 42W15 |
There is already a variable named '%1' |
|
| 42W16 |
Invalid option '%1' -- no PUBLIC setting exists |
|
| 42W17 |
Invalid setting for option '%1' |
|
| 42W18 |
User '%1' has the row in '%2' locked |
|
| 42W19 |
Not allowed while %1 is using the database |
|
| 42W20 |
CHECKPOINT command requires a rollback log |
|
| 42W21 |
Table in use |
|
| 42W22 |
Attempted two active database requests |
|
| 42W23 |
Procedure in use |
|
| 42W24 |
Label '%1' not found |
|
| 42W25 |
Invalid absolute or relative offset in FETCH |
|
| 42W26 |
Wrong number of variables in FETCH |
|
| 42W27 |
Database was initialized with an older version of the software |
|
| 42W28 |
COMMIT/ROLLBACK not allowed within atomic operation |
|
| 42W29 |
Procedure or trigger calls have nested too deeply |
|
| 42W30 |
Update operation attempted on a read-only cursor |
|
| 42W31 |
Update operation attempted on non-updatable query |
|
| 42W32 |
Cannot modify column '%1' in table '%2' |
|
| 42W33 |
Table '%1' not found |
|
| 42W34 |
User '%1' already has membership in group '%2' |
|
| 42W40 |
Duplicate referencing column |
|
| 42W41 |
Duplicate insert column |
|
| 42W42 |
Parameter name missing in call to procedure '%1' |
|
| 42W43 |
Only PUBLIC settings are allowed for option '%1' |
|
| 42W44 |
More columns are being dropped from table %1 than are defined |
|
| 42W45 |
Cannot set a temporary option for user '%1' |
|
| 42W46 |
Only the DBA can set the option %1 |
|
| 42W47 |
Parameter '%1' not found in procedure '%2' |
|
| 44000 |
WITH CHECK OPTION violated for view '%1' |
|
| 52002 |
Column '%1' found in more than one table -- need a correlation name |
|
| 52003 |
Column '%1' not found |
|
| 52009 |
Primary key column '%1' already defined |
|
| 52010 |
Item '%1' already exists |
|
| 52012 |
More than one table is identified as '%1' |
|
| 52W02 |
Correlation name '%1' not found |
|
| 52W03 |
Cannot find index named '%1' |
|
| 52W04 |
Index name '%1' not unique |
|
| 52W05 |
Table cannot have two primary keys |
|
| 52W06 |
Foreign key '%1' for table '%2' duplicates an existing foreign key |
|
| 52W07 |
Foreign key name '%1' not found |
|
| 52W08 |
There is more than one way to join '%1' to '%2' |
|
| 52W09 |
Procedure '%1' not found |
|
| 52W10 |
Trigger '%1' not found |
|
| 52W11 |
Trigger definition conflicts with existing triggers |
|
| 52W12 |
Invalid REFERENCES clause in trigger definition |
|
| 52W13 |
Dbspace '%1' not found |
|
| 52W14 |
Table '%1' is in an outer join cycle |
|
| 52W15 |
Table '%1' requires a unique correlation name |
|
| 52W16 |
User message %1 already exists |
|
| 52W17 |
User message %1 not found |
|
| 52W18 |
User-defined type %1 not found |
|
| 52W19 |
Cannot outer join a view with a UNION or GROUP BY |
|
| 52W20 |
Too many columns in table |
|
| 52W21 |
Data definition statements not allowed in procedures or triggers |
|
| 52W22 |
GRANT of column permission on view not allowed |
|
| 53002 |
Wrong number of values for INSERT |
|
| 53003 |
Function or column reference to '%1' in the select list must also appear in a GROUP BY |
|
| 53005 |
Number in ORDER BY is too large |
|
| 53011 |
Number of columns does not match SELECT |
|
| 53018 |
Cannot convert %1 to a %2 |
|
| 53023 |
Subquery allowed only one select list item |
|
| 53026 |
SELECT lists in UNION do not match in length |
|
| 53030 |
Column %1 in foreign key has a different definition than primary key |
|
| 53W01 |
ALTER clause conflict |
|
| 53W02 |
Cannot update an expression |
|
| 53W04 |
There is no way to join '%1' to '%2' |
|
| 53W05 |
Cannot alter a column in an index |
|
| 53W06 |
Cannot delete a column referenced in a trigger definition |
|
| 53W07 |
Error number %1 for RAISERROR is less than 17000 |
|
| 53W08 |
Format string argument number %1 is invalid |
|
| 53W09 |
In
valid datatype for column in WRITETEXT or READTEXT |
|
| 54003 |
Identifier '%1' too long |
|
| 55008 |
Table '%1' has no primary key |
|
| 55013 |
Table already has a primary key |
|
| 55W02 |
Table must be empty |
|
| 55W03 |
Cannot drop a user that owns tables in runtime engine |
|
| 55W04 |
Cannot drop a user that owns procedures in runtime engine |
|
| 55W05 |
Cannot drop a user that owns messages or datatypes |
|
| 57014 |
Statement interrupted by user |
|
| 5RW01 |
Publication '%1' not found |
|
| 5RW02 |
Table '%1' has publications |
|
| 5RW03 |
Subscription to '%1' for '%2' already exists |
|
| 5RW04 |
Subscription to '%1' for '%2' not found |
|
| 5RW05 |
User '%1' is already the publisher for this database |
|
| 5RW06 |
User '%1' is not a remote user for this database |
|
| 5RW07 |
Remote message type '%1' not found |
|
| 5RW08 |
Passthrough statement inconsistent with current passthrough |
|
| 5RW09 |
Remote statement failed |
|
| 99999 |
User-defined exception signalled |
|
| WB001 |
Unknown backup operation |
|
| WB002 |
Database backup not started |
|
| WB003 |
Incomplete transactions prevent transaction log renaming |
|
| WB004 |
Unable to delete database file |
|
| WB005 |
Transaction log was truncated |
|
| WI005 |
Unable to find in index '%1' for table '%2' |
|
| WI007 |
SQL Anywhere HLI internal error |
|
| WW003 |
Calling functions outside the database engine is not supported |
|
| WW004 |
Mismatch between external function platform specifier and current operating system |
|
| WW005 |
Need a dynamic library name |
|
| WW006 |
Could not load the dynamic library |
|
| WW007 |
Could not find the named function in the dynamic library |
|
| WW008 |
Could not allocate resources to call external function |
|
| WW009 |
A parameter to an external function is an unsupported datatype |
|
| WW010 |
Too many parameters to this external procedure call |
|
| WW011 |
A thread used internally could not be started |
|
| WW012 |
RAISERROR executed: %1 |
|
User's Guide