Number
|
Explanation
|
| -12001 |
Too many errors, error collection terminated |
| -12101 |
Syntax error, <%> assumed missing |
| -12102 |
Syntax error, <%> ignored |
| -12103 |
Syntax error, <%> assumed to mean <%> |
| -12104 |
Invalid construction |
| -12106 |
Internal parser error, analysis aborted |
| -12107 |
Syntax analysis resumed here |
| -12108 |
Multiple statements not allowed |
| -12109 |
Character string literal contains non-ascii character, use nchar literal instead (i.e. N'text') |
| -12110 |
Delimited identifier contains non-ascii character |
| -12120 |
Table name too long |
| -12121 |
String literal too long |
| -12122 |
Numeric literal too long |
| -12123 |
Invalid password string |
| -12124 |
<%> is an invalid hexadecimal literal |
| -12125 |
Reserved word may not be used as an identifier |
| -12126 |
Invalid name |
| -12127 |
Character string literal contains illegal UNICODE character |
| -12128 |
Result of concatenation too long |
| -12129 |
Table definition does not include any column specification |
| -12131 |
Table definition includes more than one PRIMARY KEY specification |
| -12132 |
Only one column allowed in column list |
| -12152 |
<%> not allowed in EXECUTE mode |
| -12154 |
User name too long |
| -12156 |
Column name too long |
| -12157 |
Synonym name too long |
| -12158 |
Correlation name too long |
| -12159 |
Cursor name too long |
| -12160 |
Databank name too long |
| -12161 |
Shadow name too long |
| -12162 |
Host Variable or Parameter Marker name too long |
| -12163 |
File name too long |
| -12164 |
Label name too long |
| -12165 |
Index name too long |
| -12166 |
Object name too long |
| -12167 |
View name too long |
| -12168 |
Domain name too long |
| -12169 |
Too many identifier names given |
| -12174 |
Syntax error in escape clause, expecting comma before PRODUCT or CONFORMANCE specification |
| -12175 |
Syntax error in escape clause, invalid CONFORMANCE specification |
| -12176 |
Syntax error in escape clause, invalid YEAR specification |
| -12177 |
Syntax error in escape clause, invalid PRODUCT specification |
| -12178 |
Syntax error in escape clause, invalid VENDOR specification |
| -12179 |
Syntax error in escape clause, expecting VENDOR or YEAR after '--(*' |
| -12180 |
Syntax error, unexpected token '*)--' |
| -12181 |
Syntax error in escape clause, terminating '*)--' missing |
| -12182 |
Syntax error in escape clause |
| -12200 |
Table <%> not found, table does not exist or no access privilege |
| -12201 |
Table reference <%> is ambiguous |
| -12202 |
<%> is not a column of an inserted table, updated table or any table identified in a FROM clause |
| -12203 |
<%> is neither an object table of an INSERT, UPDATE or DELETE statement, nor specified in a FROM clause |
| -12204 |
Column reference <%> ambiguous |
| -12205 |
Column <%> not referenced in GROUP BY clause |
| -12207 |
DISTINCT specified more than once in a subselect |
| -12208 |
SELECT clause of a subquery specifies more than one column |
| -12209 |
Column <%> identified in HAVING clause but not included in GROUP BY clause |
| -12210 |
Operand of set function includes a set function |
| -12211 |
NEXT_VALUE of sequence not allowed in ORDER BY clause |
| -12212 |
Operand of set function includes a correlated reference specified in an expression |
| -12213 |
Set function not specified in a SELECT clause or HAVING clause |
| -12214 |
Invalid operand type, expected type is <%> |
| -12215 |
Operand not of <%> type |
| -12216 |
Operands are not comparable |
| -12217 |
Set function containing DISTINCT may not be specified within an expression |
| -12218 |
Constant expression not allowed in ORDER BY clause |
| -12219 |
The length of the trim character expression is not one |
| -12220 |
Expression must be a column |
| -12221 |
SELECT clause contains both column expressions and set function expressions |
| -12222 |
ORDER BY expression contains no valid column reference |
| -12223 |
ORDER BY clause invalid because it includes a column name that is not part of the result table |
| -12224 |
ORDER BY clause invalid because it includes an integer which does not identify a column of the result table |
| -12225 |
The ORDER BY clause is invalid because it includes an ambiguous column reference |
| -12226 |
Set function argument not bound in HAVING context |
| -12227 |
Duplicate column reference in FOR UPDATE OF clause |
| -12228 |
ORDER BY clause must contain only SELECT list items when DISTINCT, GROUP BY or UNION is specified |
| -12229 |
Set function not allowed in ORDER BY clause |
| -12230 |
Invalid numeric literal |
| -12231 |
Update or insert value is NULL, but the object column <%> cannot contain NULL values |
| -12232 |
Insert value must be a constant expression or NULL |
| -12233 |
The number of insert values is not the same as the number of object columns |
| -12234 |
Update or insert value not compatible with the data type of the object column <%> |
| -12235 |
Subquery not allowed in ORDER BY clause |
| -12236 |
Column name <%> does not identify a unique column of the result table |
| -12237 |
User defined type <%> not found, does not exist or no usage privilege |
| -12238 |
Column <%> cannot be updated because it is derived from a set function or expression |
| -12239 |
The use of NULL in a SELECT clause is only allowed in a UNION |
| -12240 |
Statement contains too many table references |
| -12241 |
Domains not allowed in parameter list |
| -12242 |
The corresponding columns of the operands of a UNION do not have compatible column descriptions |
| -12243 |
Result table contains a column for which the type cannot be determined |
| -12244 |
Operands of a UNION do not have the same number of columns |
| -12245 |
FOR UPDATE clause may not be specified because the result table cannot be modified |
| -12246 |
Column <%> in the FOR UPDATE clause is not part of the identified table or view |
| -12250 |
A host variable or parameter marker is not allowed in a view definition |
| -12251 |
CREATE VIEW statement must include a column list because the SELECT clause contains an expression |
| -12252 |
CREATE VIEW statement must include a column list because the SELECT clause contains duplicate column names |
| -12253 |
The number of columns specified for the view is not the same as specified by the SELECT clause |
| -12254 |
WITH CHECK OPTION cannot be used for the specified view because it cannot be modified |
| -12258 |
<%> operation not permitted because the view cannot be modified |
| -12259 |
<%> operation not permitted because the joined table cannot be modified |
| -12260 |
LOAD operation not permitted, the table contains a trigger specification |
| -12261 |
INSERT statement not permitted because the object column <%> is derived from an expression |
| -12262 |
The type of the parameter marker cannot be determined |
| -12263 |
Parameter markers and host variables not allowed in EXECUTE IMMEDIATE environment |
| -12264 |
Parameter markers may not be specified in SELECT clause |
| -12265 |
Literal or computed value overflow |
| -12266 |
Decimal divide operation invalid because the result would have a negative scale |
| -12267 |
Duplicate column reference in INSERT column list |
| -12268 |
Duplicate column reference in UPDATE set clauses |
| -12269 |
Duplicate column reference in View Parameter |
| -12270 |
<%> does not have <%> privilege on object <%> |
| -12271 |
Duplicate column reference in GROUP BY clause |
| -12273 |
The types of the results of a CASE expression are not type compatible |
| -12274 |
The type of the CASE expression result cannot be determined |
| -12275 |
At least one result in a CASE expression must be non-null |
| -12277 |
Invalid CAST data type specification |
| -12278 |
Invalid EXTRACT field specification |
| -12280 |
<%> is an invalid datetime literal |
| -12281 |
<%> is an invalid interval literal |
| -12282 |
Invalid interval qualifier |
| -12283 |
Invalid use of interval qualifier |
| -12300 |
Syntax error in escape clause |
| -12301 |
Translated native SQL string was truncated |
| -12302 |
The function <%> is not supported |
| -12303 |
Unrecognized first word, <%> in escape clause expected 'CALL', 'FN','OJ', 'D', 'T' or 'TS' |
| -12304 |
Unrecognized scalar function <%> |
| -12305 |
Invalid data type <%> in function CONVERT |
| -12306 |
Syntax error, incomplete escape clause |
| -12307 |
Syntax error, unmatched apostrophe in string literal |
| -12308 |
Syntax error, unmatched quote in delimited identifier |
| -12309 |
Unknown first parameter <%> in scalar function <%> |
| -12310 |
Argument missing in scalar function <%> |
| -12311 |
Too many arguments in scalar function <%> |
| -12500 |
A databank named <%> already exists (or filename already used) |
| -12501 |
Table <%> does not exist |
| -12502 |
<%> does not have <%> privilege |
| -12503 |
<%> does not have <%> privilege on object <%> |
| -12504 |
Statement not allowed within transaction |
| -12505 |
<%> is not a USER or PROGRAM ident |
| -12506 |
No privilege |
| -12507 |
<%> does not have any databank available (see CREATE DATABANK) |
| -12509 |
An ident cannot REVOKE a privilege from itself |
| -12510 |
An ident cannot GRANT a privilege to itself |
| -12511 |
Duplicate column specification |
| -12512 |
Invalid type description |
| -12513 |
The cascade option would cause a drop of the last column <%> for table <%> in schema <%> |
| -12514 |
The value for <%> must be between <%> and <%> |
| -12515 |
The value of <%> must be <%> than or equal to the value of <%> |
| -12516 |
Qualified column name required |
| -12517 |
Object <%> does not exist |
| -12518 |
Circular grant of membership between groups not permitted |
| -12520 |
An ident cannot GRANT a privilege to itself |
| -12521 |
Create databank option <%> specified more than once |
| -12522 |
Alter databank option <%> specified more than once |
| -12523 |
Databank <%> does not exist |
| -12524 |
READ ONLY option only available for ALTER DATABANK |
| -12525 |
Alter table option <%> specified more than once |
| -12526 |
Default value for NOT NULL column <%> missing |
| -12527 |
Constraints and unique indexes must be specified WITHOUT CHECK when the database is set to AUTOUPGRADE |
| -12528 |
It is not allowed to create a shadow when the database is set to AUTOUPGRADE |
| -12529 |
The database can not be set to AUTOUPGRADE when there are shadows defined |
| -12530 |
Operand not of type <%> |
| -12531 |
Operands not comparable |
| -12533 |
Literal or computed value overflow |
| -12534 |
Invalid numeric literal |
| -12535 |
Invalid identifier, keyword VALUE expected |
| -12536 |
Name <%> in PRIMARY KEY specification not recognized as a column name of current table definition |
| -12537 |
<%> must be unqualified |
| -12538 |
Default value not compatible with domain definition |
| -12539 |
Host variable construction illegal in this context |
| -12540 |
<%> is not a column of the specified table(s) |
| -12541 |
Data pagesize too small for table record length |
| -12542 |
Default value is outside the range specified by domain definition |
| -12543 |
Index pagesize too small for table key length |
| -12544 |
Too many columns specified in <%> statement |
| -12545 |
Primary key column <%> may not be updated because the table is in a WORK databank |
| -12546 |
Column <%> is not type compatible with the corresponding column of the referenced table |
| -12547 |
Number of columns specified in the foreign key is not the same as the number of columns in the primary key of the referenced table |
| -12549 |
Databank option may not be changed to WORK since <%> contains tables with FOREIGN KEY, REFERENCE, UNIQUE or trigger specifications |
| -12550 |
Table <%> includes a FOREIGN KEY or UNIQUE constraint and may therefore not be created in a databank with WORK option |
| -12551 |
Table <%> is in a databank with WORK option and may therefore not be used as referential constraint |
| -12552 |
A UNIQUE index can not be created for table <%> as it is located in a databank with WORK option |
| -12553 |
Explicit grant membership on PUBLIC is not permitted |
| -12554 |
PUBLIC cannot be member of another group |
| -12555 |
The option can not be changed to READ ONLY since <%> contains a table using a current collation |
| -12556 |
<%> cannot be shadowed because it is a WORK databank |
| -12557 |
Shadow named <%> already exists |
| -12558 |
Ident named <%> already exists |
| -12559 |
Index named <%> already exists |
| -12560 |
Table, View or Synonym named <%> already exists |
| -12561 |
Domain <%> not found, domain does not exist or no usage privilege |
| -12563 |
Shadow <%> does not exist |
| -12564 |
Ident <%> does not exist |
| -12565 |
Maximum row length exceeded by index or key table |
| -12566 |
Maximum row length exceeded by base table |
| -12568 |
EXISTS construction illegal in this context |
| -12569 |
ALL or ANY construction illegal in this context |
| -12570 |
Set function construction illegal in this context |
| -12571 |
Subquery construction illegal in this context |
| -12572 |
Too many columns given in FOREIGN KEY clause |
| -12573 |
Name <%> in CHECK clause not recognized as a column name of current table definition |
| -12574 |
Name <%> in column constraint not recognized as current column name |
| -12577 |
Default value not compatible with column specification |
| -12579 |
No such unique constraint in referenced table |
| -12581 |
Too many columns given in UNIQUE constraint |
| -12582 |
UNIQUE constraint equivalent to PRIMARY KEY constraint |
| -12583 |
UNIQUE constraint equivalent to previously given UNIQUE constraint |
| -12585 |
Name <%> in FOREIGN KEY clause not recognized as a column name of current table definition |
| -12586 |
Data pagesize not supported |
| -12587 |
Index pagesize not supported |
| -12588 |
Compression <%> not supported |
| -12589 |
An ident or a schema owning any collation cannot be dropped. Drop collation first |
| -12590 |
Table contains too many columns |
| -12591 |
Cannot create unique index |
| -12592 |
Dependencies exist, RESTRICT specified |
| -12593 |
Column <%> does not exist |
| -12594 |
Column <%> cannot be dropped as it is the only column in table |
| -12595 |
Column <%> cannot be dropped, dependencies exist |
| -12596 |
Default value for column <%> does not exist |
| -12597 |
Change of data type is not allowed for a column included in a key or index |
| -12598 |
The datatype for a column can not be changed to/from a domain or user defined type |
| -12599 |
The proposed data type change is not supported |
| -12600 |
Change of data type is not supported for a column used by a view, routine or trigger |
| -12601 |
Statement does not support backup of <%> |
| -12602 |
The same file name is given for backup and incremental backup |
| -12603 |
Database is already OFFLINE |
| -12604 |
Database is already ONLINE |
| -12605 |
Cannot RESET LOG, because database is ONLINE |
| -12606 |
Databank <%> is already OFFLINE |
| -12607 |
Databank <%> is already ONLINE |
| -12608 |
Cannot RESET LOG, because databank <%> is ONLINE |
| -12609 |
Shadow <%> is already OFFLINE |
| -12610 |
Shadow <%> is already ONLINE |
| -12611 |
Cannot RESET LOG, because shadow <%> is ONLINE |
| -12612 |
Shadow <%> is already specified |
| -12613 |
Cannot set more than one shadow OFFLINE for databank having shadow <%> |
| -12614 |
Statistics cannot be updated for <%> because it is a view |
| -12615 |
Filename already used by databank or shadow |
| -12616 |
Cannot SET DATABASE OFFLINE, because another user is connected |
| -12617 |
Cannot SET DATABANK <%> OFFLINE, because the databank is in use |
| -12618 |
INCREMENTAL backups can only be used in conjunction with EXCLUSIVE |
| -12620 |
A domain or user-defined type named <%> already exists |
| -12621 |
A schema named <%> already exists |
| -12622 |
The schema name for the index table must be the same as the schema name for the table |
| -12623 |
A PRIMARY KEY constraint for this table has already been defined |
| -12624 |
The added PRIMARY KEY or UNIQUE constraint cannot be created as there are duplicates |
| -12625 |
The added referential constraint is not fulfilled by existing records |
| -12626 |
The added check constraint criteria is not fulfilled by existing records |
| -12627 |
One or more specified columns does not exist in table |
| -12628 |
Referenced table or column not found |
| -12629 |
FOREIGN KEY not referencing a compatible UNIQUE or PRIMARY KEY |
| -12630 |
Constraint <%> cannot be dropped, dependencies exist |
| -12631 |
PRIMARY KEY or UNIQUE column constraint not valid when records exist |
| -12632 |
Collation <%> does not exist |
| -12633 |
A collation named <%> already exists |
| -12634 |
Invalid collation definition string |
| -12635 |
Collation <%> cannot be dropped, used by domain or column |
| -12636 |
A collate clause can only be specified for character types |
| -12637 |
Expressions with different collating sequences can not be compared |
| -12638 |
Collation specified in ORDER BY must be the same as used in DISTINCT/UNION |
| -12639 |
Column of type LARGE OBJECT not allowed in PRIMARY KEY, UNIQUE, FOREIGN KEY or INDEX |
| -12640 |
Precompiled statement <%> does not exist or no execute privilege |
| -12641 |
A precompiled statement named <%> already exists |
| -12642 |
Invalid SQL construction used in CREATE STATEMENT |
| -12643 |
Column of datatype LARGE OBJECT not allowed in this context |
| -12644 |
SQL syntax error, only EXECUTE STATEMENT allowed |
| -12645 |
Column of datatype LARGE OBJECT not allowed in a databank having shadow |
| -12646 |
Precompiled statement is not scrollable |
| -12647 |
Precompiled statement is scroll only |
| -12648 |
Not allowed to change table as it is used by a precompiled statement |
| -12650 |
Only the creator of a precompiled statement may alter it |
| -12651 |
Invalid syntax in statement invocation |
| -12660 |
No column result set |
| -12661 |
The datatype list does not match any routine |
| -12662 |
There is no matching routine with the specified number of parameters |
| -12670 |
Support for user defined types is not included in this version |
| -12671 |
Support for read only databanks is not included in this version |
| -12672 |
Support for this diagnostic item is not included in this version |
| -12673 |
CURRENT_COLLATION not allowed for column in unique constraint |
| -12674 |
CURRENT_COLLATION not allowed for column in primary key |
| -12675 |
CURRENT_COLLATION not allowed for column in unique index |
| -12676 |
Collation <%> may not be used as base since it is binary |
| -12678 |
INSERT columns must be specified when CREATE STATEMENT, i.e. INSERT INTO table (column-list) ... |
| -12679 |
SELECT * not allowed when CREATE STATEMENT, specify selected columns (at top level) |
| -12701 |
<%> is a reserved word, and cannot be used as the name for a symbol |
| -12702 |
<%> is a global variable, and cannot be used as the name for a variable or parameter |
| -12703 |
The class <%> is already present in the handler declaration |
| -12704 |
The SQLSTATE <%> is already present in the handler declaration |
| -12705 |
The condition identifier <%> is already present in the handler declaration |
| -12706 |
The condition identifier <%> is already used in another handler in this scope |
| -12707 |
A condition identifier for the SQLSTATE <%> has already been defined in this scope |
| -12708 |
<%> is not a valid SQLSTATE value |
| -12709 |
The SQLSTATE <%> associated with the condition identifier <%> is already present in the handler declaration |
| -12710 |
An exception handler for the state (<%>) associated with the condition identifier <%> has already been defined in this scope |
| -12711 |
An exception handler for the state <%> has already been defined in this scope |
| -12712 |
An exception handler for the class <%> has already been defined in this scope |
| -12713 |
The default literal is too large for this data type |
| -12714 |
The literal value is too large for this data type |
| -12715 |
The type of the default value is not compatible with the type of the variable |
| -12717 |
Invalid declaration. The maximum precision for this data type is <%> |
| -12718 |
The scale cannot exceed the precision |
| -12720 |
The number of correlation names for <%>, does not match number of result types |
| -12721 |
The parameter <%> must be declared as IN as it is defined in a function, method or result set procedure |
| -12722 |
The parameter <%> is declared as IN, and cannot be assigned |
| -12723 |
The parameter <%> is declared as OUT, and cannot be used in expressions |
| -12724 |
<%> cannot be assigned a value directly |
| -12725 |
Result set procedures can only be used in cursor declarations |
