Reference Manual CHAPTER 10. Database Error Messages
SQLCODE
Message
-737
Signature '%1' does not match procedure parameters
-736
The datatype of column '%1' is not supported.
-735
Invalid parameter.
-734
Cannot update or delete an all-NULL row from table '%1'.
-733
Number of columns allowing NULLs exceeds limit.
-732
Creating remote tables with computed columns is not supported.
-731
Cannot drop a user that owns objects involved in replication
-730
Invalid jar file
-729
The specified foreign key (%1) can not be enforced.
-728
Update operation attempted on non-updatable remote query
-727
The optimizer was unable to construct a valid access plan.
-726
The table specification '%1' identifies more than one remote table.
-725
Identity attribute mismatch for column '%1'.
-724
Null attribute mismatch for column '%1'.
-723
The length specified for column '%1' is different than the actual length.
-722
The column '%1' does not exist in the remote table.
-721
The datatype specified for column '%1' is not compatible with the actual datatype.
-720
VALIDATE TABLE statement must refer to a base table
-719
RESTORE unable to start database '%1'
-718
RESTORE unable to write to file '%1'
-717
RESTORE unable to open file '%1'
-716
Backup file format is invalid
-715
Contents of backup files are inconsistent
-714
Invalid operation on a closed '%1'
-713
An internal error occurred in a '%1'
-712
External login for server %1 could not be found.
-711
Incorrect store DLL (%1) version.
-710
Invalid comparison
-709
Computed columns are not supported in this database
-708
READTEXT or WRITETEXT statement cannot refer to a view
-707
Statement is not allowed in passthrough mode
-706
Remote server does not have the ability to support this command.
-705
Return type of void from procedure '%1' cannot be used in any expression
-704
Cannot create an index on Java class '%1'
-703
Cannot insert or update computed column '%1'
-702
TRUNCATE TABLE statement cannot refer to a view
-701
Cannot access instance member through a class
-700
SQLDA fields inconsistent for a multi-row SQLDA
-699
Cannot update final member fields
-698
The remote server does not support an auto-incrementing datatype.
-697
Error during backup: %1
-696
-695
-694
Could not change an opened prepared statement or callable statement
-693
JDBC feature '%1' not supported
-692
Could not execute backup/restore DLL (%1) entry point.
-691
Could not load the backup/restore DLL %1
-690
Return value cannot be set
-689
Input parameter index out of range
-687
Syntax error, cannot specify IQ specific options without specifying IQ PATH
-686
Cannot make a static reference to nonstatic variable '%1' in class '%2'
-684
Rollback occurred due to deadlock during prefetch
-683
The cursor name '%1' already exists
-682
%1
-681
Invalid join type used with Transact-SQL outer join
-680
Invalid expression in WHERE clause of Transact-SQL outer join
-679
Not enough memory is allocated to the Java virtual machine for remote access.
-678
Index name '%1' is ambiguous
-677
Table '%1' has a foreign key with a referential action
-676
The specified transaction isolation is invalid
-675
Java virtual machine could not be started
-674
Statement's size limit is invalid.
-673
Database upgrade not possible
-672
Database upgrade failed
-671
Parameter not registered as output parameter
-670
Invalid class byte code
-669
Method '%1' cannot be called at this time
-668
Cursor is restricted to FETCH NEXT operations
-667
Could not access column information for the table '%1'.
-666
The remote table '%1' could not be found.
-665
Database %1 needs recovery
-664
Database is active
-663
Cannot deserialize Java object
-662
Cannot serialize Java object with class %1
-661
Backwards scrolling cursors are not supported for remote objects.
-660
Server %1: %2
-659
Remote server %1 could not be found. Add the server using CREATE SERVER.
-658
Remote server %1 is currently configured as read only.
-657
Remote objects %1 does not exist.
-656
Unable to connect to server '%1': %2
-655
Error parsing connection parameter string.
-654
The connection parameters file could not be found.
-653
Cannot remove class '%1': member of Jar
-652
Could not decompress class '%1' from Jar.
-651
An attempt to delete database '%1' failed.
-650
Index type specification of '%1' is invalid.
-649
Field '%1' of class '%2' cannot be null
-648
Cannot create item (%1) in the specified dbspace.
-647
Could not execute store DLL (%1) entry point.
-646
Could not load the store DLL %1
-645
Database creation failed
-644
Invalid database page size
-642
Invalid SQL descriptor name
-641
Error in assignment
-640
Invalid descriptor index
-639
Parameter name missing in call to procedure '%1'
-638
Right truncation of string data
-637
Duplicate insert column
-636
Duplicate referencing column
-635
GRANT of column permission on view not allowed
-634
Unterminated C string
-633
Update operation attempted on a read-only cursor
-632
WITH CHECK OPTION violated for insert/update on base table '%1'
-631
RAISERROR executed: %1
-630
Invalid escape sequence '%1'
-629
Invalid escape character '%1'
-628
Division by zero
-627
Disallowed language extension detected in syntax near '%1'
-626
A thread used internally could not be started
-625
Too many parameters to this external procedure call
-624
Expression has unsupported datatype
-623
Data definition statements not allowed in procedures or triggers
-622
Could not allocate resources to call external function
-621
Could not find '%1' in dynamic library '%2'
-620
Could not load dynamic library '%1'
-619
Need a dynamic library name
-618
Mismatch between external function platform specifier and current operating system
-617
Calling functions outside the database engine is not supported
-616
Too many columns in table
-615
Parameter '%1' not found in procedure '%2'
-614
Cannot drop a user that owns messages or datatypes
-613
User-defined type %1 not found
-612
User message %1 not found
-611
Transact-SQL feature not supported
-610
User message %1 already exists
-609
Invalid datatype for column in WRITETEXT or READTEXT
-608
Invalid TEXTPTR value used with WRITETEXT or READTEXT
-313
The loginid '%1' has not been mapped to any database userid
-312
User '%1' already has membership in group '%2'
-309
Memory error -- transaction rolled back
-308
Connection was terminated
-307
All threads are blocked
-306
Deadlock detected
-305
I/O error %1 -- transaction rolled back
-304
Disk full '%1' -- transaction rolled back
-302
Terminated by user -- transaction rolled back
-301
Internal database error %1 -- transaction rolled back
-300
Run time SQL error -- %1
-299
Statement interrupted by user
-298
Attempted two active database requests
-297
User-defined exception signalled
-296
Error number %1 for RAISERROR is less than 17000
-295
Cannot uniquely identify rows in cursor
-294
Format string argument number %1 is invalid
-288
Remote statement failed
-287
Passthrough statement inconsistent with current passthrough
-286
Remote message type '%1' not found
-285
User '%1' is not a remote user for this database
-284
User '%1' is already the publisher for this database
-283
Subscription to '%1' for '%2' not found
-282
Subscription to '%1' for '%2' already exists
-281
Table '%1' has publications
-280
Publication '%1' not found
-275
Triggers and procedures not supported in runtime engine
-274
Procedure or trigger calls have nested too deeply
-273
COMMIT/ROLLBACK not allowed within trigger actions
-272
Invalid REFERENCES clause in trigger definition
-271
Trigger definition conflicts with existing triggers
-270
Cannot drop a user that owns procedures in runtime engine
-269
Cannot delete a column referenced in a trigger definition
-268
Trigger '%1' not found
-267
COMMIT/ROLLBACK not allowed within atomic operation
-266
Database was initialized with an older version of the software
-265
Procedure '%1' not found
-264
Wrong number of variables in FETCH
-263
Invalid absolute or relative offset in FETCH
-262
Label '%1' not found
-261
There is already a variable named '%1'
-260
Variable '%1' not found
-251
Foreign key '%1' for table '%2' duplicates an existing foreign key
-250
Identifier '%1' too long
-249
The loginid '%1' is already mapped to userid '%2'
-248
Cannot map a loginid to the sys or public userid
-247
The integrated loginid guest can only be mapped to the guest database userid
-246
Integrated logons are not supported for this database
-245
Integrated logon failed
-244
Transaction log was truncated
-243
Unable to delete database file
-242
Incomplete transactions prevent transaction log renaming
-241
Database backup not started
-240
Unknown backup operation
-232
Server/database engine version mismatch
-231
Dblib/database engine version mismatch
-230
Sqlpp/dblib version mismatch
-222
Result set not allowed from within an atomic compound statement
-221
ROLLBACK TO SAVEPOINT not allowed
-220
Savepoint '%1' not found
-218
Authentication failed
-217
The option %1 cannot be set from within a procedure
-216
The option %1 can only be set as a temporary option
-215
Procedure in use
-214
Table in use
-213
Savepoints require a rollback log
-212
CHECKPOINT command requires a rollback log
-211
Not allowed while %1 is using the database
-210
User '%1' has the row in '%2' locked
-209
Invalid value for column '%1' in table '%2'
-208
Row has changed since last read -- operation cancelled
-207
Wrong number of values for INSERT
-206
Standard logons are not permitted
-205
Integrated logons are not permitted
-204
Only the DBA can set the option %1
-203
Cannot set a temporary option for user '%1'
-202
Only PUBLIC settings are allowed for option '%1'
-201
Invalid setting for option '%1'
-200
Invalid option '%1' -- no PUBLIC setting exists
-199
INSERT/DELETE on cursor can modify only one table
-198
Primary key for row in table '%1' is referenced in another table
-197
No current row of cursor
-196
Index '%1' for table '%2' would not be unique
-195
Column '%1' in table '%2' cannot be NULL
-194
No primary key value for foreign key '%1' in table '%2'
-193
Primary key for table '%1' is not unique
-192
Update operation attempted on non-updatable query
-191
Cannot modify column '%1' in table '%2'
-190
Cannot update an expression
-189
Unable to find in index '%1' for table '%2'
-188
Not enough values for host variables
-187
Illegal cursor operation attempt
-186
Subquery cannot return more than one result
-185
SELECT returns more than one row
-183
Cannot find index named '%1'
-182
Not enough fields allocated in SQLDA
-181
No indicator variable provided for NULL result
-180
Cursor not open
-172
Cursor already open
-171
Error opening cursor
-170
Cursor has not been declared
-165
Java VM Heap Exhausted at Internal fn: %1
-164
Namespace Heap Exhausted at Internal fn: %1
-163
Derived table '%1' has no name for column %2
-161
Invalid type on DESCRIBE statement
-160
Can only describe a SELECT statement
-159
Invalid column number
-158
Value %1 out of range for destination
-157
Cannot convert %1 to a %2
-156
Invalid expression near '%1'
-155
Invalid host variable
-154
Wrong number of parameters to function '%1'
-153
SELECT lists in UNION do not match in length
-152
Number in ORDER BY is too large
-151
Subquery allowed only one select list item
-150
Aggregate functions not allowed on this statement
-149
Function or column reference to '%1' in the select list must also appear in a GROUP BY
-148
Unknown function '%1'
-147
There is more than one way to join '%1' to '%2'
-146
There is no way to join '%1' to '%2'
-145
Foreign key name '%1' not found
-144
Column '%1' found in more than one table -- need a correlation name
-143
Column '%1' not found
-142
Correlation name '%1' not found
-141
Table '%1' not found
-140
Userid '%1' does not exist
-139
More than one table is identified as '%1'
-138
Dbspace '%1' not found
-137
Table '%1' requires a unique correlation name
-136
Table '%1' is in an outer join cycle
-135
Language extension
-134
Feature '%1' not implemented
-133
Invalid prepared statement type
-132
SQL statement error
-131
Syntax error near '%1'
-130
Invalid statement
-128
Cannot drop a user that owns tables in runtime engine
-127
Cannot alter a column in an index
-126
Table cannot have two primary keys
-125
ALTER clause conflict
-124
More columns are being dropped from table %1 than are defined
-123
User '%1' is not a user group
-122
Operation would cause a group cycle
-121
Do not have permission to %1
-120
User '%1' already has grant permission
-119
Primary key column '%1' already defined
-118
Table '%1' has no primary key
-116
Table must be empty
-114
Number of columns defined for the view does not match SELECT statement
-113
Column %1 in foreign key has a different definition than primary key
-112
Table already has a primary key
-111
Index name '%1' not unique
-110
Item '%1' already exists
-109
There are still active database connections
-108
Connection not found
-107
Error writing to log file
-106
Cannot open log file %1
-105
Cannot be started -- %1
-104
Invalid userid and password on preprocessed module
-103
Invalid userid or password
-102
Too many connections to database
-101
Not connected to SQL database
-100
Database engine not running
-99
Connections to database have been disabled
-98
Authentication violation
-97
Database's page size too big
-96
Database engine already running
-95
Parse error: %1 near '%2'.
-94
Invalid type for field reference
-93
Class '%1' has no public field '%2'
-92
'%1' is not a valid class file
-91
Procedure '%1' terminated with unhandled exception '%2'
-90
Argument %1 of procedure '%2' cannot be null
-89
Database engine not running in multi-user mode
-88
Application/engine communications protocol version mismatch
-87
Database name required to start engine
-86
Not enough memory to start
-85
Communication error
-84
Specified database is invalid
-83
Specified database not found
-82
Unable to start specified database
-81
Invalid database engine command line
-80
Unable to start database engine
-79
Invalid local database switch
-78
Dynamic memory exhausted!
-77
Database name not unique
-76
Request denied -- no active databases
-75
Request to start/stop database denied
-74
The selected database is currently inactive
-73
Communication buffer underflow
-72
No database file specified
0
(no message)
100
Row not found
No data
101
Value truncated
102
Using temporary table
103
Invalid data conversion
104
Row has been updated since last time read
105
Procedure has completed
106
Value for column '%1' in table '%2' has changed
107
Language extension detected in syntax
108
Cursor operation conflict
109
Null value eliminated in aggregate function
110
Transaction log backup page only partially full
111
Statement cannot be executed
112
More info required
113
Database option '%1' for user '%2' has an invalid setting
114
Character set translation to '%1' cannot be performed; '%2' is used instead
115
Unsupported character set '%1'
116
Unsupported language; language used is '%1' instead
117
Unsupported character set '%1' and unsupported language; language used is '%2' instead
118
Illegal user selectivity estimate specified.
200
Warning