Mimer SQL Programmer's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Internal Mimer SQL Return Codes


Here the internal Mimer SQL return code values are listed together with the associated text message. See Run-time Errors for details on how to retrieve this information after an exception has been raised.

The codes are grouped according to function as follows:

Code numbers
Functional group
> 0
Warnings, messages
= 0
Success
100
No data
-100 to -999
ODBC error codes
-10000 to -10999
Data-dependent errors
-11000 to -11999
Limits exceeded
-12000 to -12999
SQL statement errors
-13000 to -13999
Not currently used
-14000 to -14999
Program-dependent errors
-15000 to -15999
Not currently used
-16000 to -16999
Databank and table errors
-17000 to -17999
Not currently used
-18000 to -18999
Miscellaneous errors
-19000 to -19999
Internal errors
-20000 to -20999
Not currently used
-21000 to -21999
Communication errors
-22000 to -22999
JDBC error codes

Corrective action is given in general terms for each group of codes. When reporting errors to Mimer support, make sure you include the internal Mimer SQL return code.

Warnings and Messages

No corrective action is normally required for internal Mimer SQL return code values greater than zero.

Number
Explanation
54
Character string was truncated
55
Insufficient item descriptor areas
56
Privilege not revoked
57
Privilege not granted
58
Zero bits were added to the binary string
90
Login failure
91
Soft enter performed
92
No cursor state was saved on stack
94
Message text not found
100
Row not found for FETCH, UPDATE or DELETE, or the result of a query is an empty table
100
No data - Item number is greater than the value of count

ODBC Errors and Warnings

These errors occur when ODBC calls to Mimer SQL fail for some reason.

Number
Explanation
-100
Illegal sequence
-101
Out of memory
-102
Option out of range
-103
Function not supported
-104
Connection not open
-105
Connection in use
-106
Invalid argument value
-107
Invalid transaction operation code
-108
Internal network buffer overflow
-109
Invalid C data type
-110
Invalid SQL data type
-111
Bad address
-112
Function already active
-113
Operation canceled
-114
Wrong number of parameters
-115
Use ODBC function SQLTransact to commit or rollback transaction
-116
Statement is not in a prepared state
-117
Invalid transaction state
-118
Unknown statement type
-119
Unknown internal data type
-120
Extype corrupt
-121
Invalid buffer length
-122
String data truncated
-123
Numeric data truncated
-124
Numeric value out of range
-125
Invalid numeric value
-126
Bad parameter passed to numeric package
-127
Invalid column number
-128
Database name mandatory
-129
Connect dialog failed
-130
Data truncated
-131
Invalid connection string attribute
-132
Invalid cursor state
-133
Invalid parameter number
-134
Descriptor type out of range
-135
Invalid type passed to DICOA3
-136
Function type out of range
-137
Invalid cursor name
-138
Duplicate cursor name
-139
Cursor hash table corrupt
-140
ODBC database control block chain corrupt
-141
Option type out of range
-142
Option value not supported
-143
Option not supported
-144
Invalid row or keyset size
-145
Invalid concurrency option
-146
Invalid fetch type
-147
Not a scrollable cursor
-148
Row position out of range
-149
Only one SQLPutData for fixed length parameter
-150
SQLPutData does not support block cursors
-151
Driver not capable
-152
Table type out of range
-153
Invalid string length
-154
Data type out of range
-155
Syntax error found in escape clause
-156
DDO buffer overflow
-157
Uniqueness option type out of range
-158
Accuracy option type out of range
-159
Column type out of range
-160
Scope type out of range
-161
Nullable type out of range
-162
Internal type mismatch
-163
Conversion between data types not supported
-164
Invalid date, time, or timestamp
-165
Restricted data type attribute violation
-166
Date, time, or timestamp data truncated
-167
Database has not been configured. Run Configure MIMER 7.1
-168
Translated native SQL string was truncated
-169
ODBC extension DATE, TIME or TIMESTAMP is not supported
-170
ODBC extension OUTER JOIN is not supported
-171
ODBC extension for procedure invocation is not supported
-172
Unrecognized first word in escape clause, expected 'CALL','FN','OJ','D','T' or 'TS'
-173
This server version does not support the used scalar function
-174
Unrecognized scalar function found in escape clause
-175
Argument missing in scalar function
-176
Too many arguments in scalar function
-177
Syntax error, incomplete escape clause
-178
Syntax error, unmatched apostrophe in string literal
-179
Syntax error, unmatched quote in delimited identifier
-180
Invalid data type specified in scalar function CONVERT
-181
Information type out of range
-182
Parameter type may only be used with procedures
-183
Parameter type out of range
-184
Update and delete where current fully supported (not simulated)
-185
Option value changed
-186
Static scrollable cursor used instead of keyset or dynamic cursor
-187
Error in row, please check next error code
-188
Cancel treated as FreeStatement/CLOSE
-189
Attempt to fetch before the result set returned the first rowset
-190
Invalid cursor position
-191
Unknown first parameter in scalar function TIMESTAMPADD
-192
Unknown first parameter in scalar function TIMESTAMPDIFF
-193
Bad parameter passed to datetime package
-194
Out of critical section objects
-196
Invalid attribute option identifier
-197
Attribute cannot be set now
-198
General error
-199
Invalid use of an automatically allocated descriptor
-200
Invalid descriptor field identifier
-201
Invalid descriptor index
-202
Associated statement not prepared
-203
Interval second fraction truncated
-204
Interval truncation error
-205
Interval convert error
-206
Year to month interval cannot be converted to a numeric value because it is not a single field
-207
Interval cannot be converted to a numeric value because it is not a single field
-208
Invalid interval literal
-209
Interval leading field truncation error
-210
Interval trailing field truncated
-211
Binary data truncated
-212
Binary truncation error
-213
Binary length invalid
-214
Binary data invalid
-215
Binary not supported
-216
Inconsistent descriptor information
-217
Cannot modify IRD
-218
Invalid use of null pointer
-219
Character data not hexadecimal
-220
Internal error
-221
Significant parts of datetime/interval string truncated
-222
Interval field truncation
-223
String data truncated
-224
Binary data truncated
-225
String data truncated
-226
Binary data truncated

Data-dependent Errors

These errors arise when an SQL statement cannot be executed correctly because of the data content of variables, expressions, and so on in the statement. The appropriate corrective action is determined by the nature of the error and the specific context in the application program.

Number
Explanation
-10001
Transaction aborted due to conflict with other transaction
-10100
PRIMARY KEY constraint violation, attempt to insert NULL value
-10101
PRIMARY KEY constraint violation, attempt to insert duplicate value
-10102
Domain constraint violation <%>
-10103
Table constraint violation <%>
-10104
View constraint violation <%>
-10105
INSERT or UPDATE operation invalid because the referencing table <%> does not satisfy a referential constraint
-10106
UPDATE or DELETE operation invalid because the referenced table <%> does not satisfy a referential constraint
-10107
The result of a subquery in a basic predicate is more than one value
-10108
Result of SELECT INTO or EXECUTE INTO statement is a table of more than one row
-10109
Type constraint violation
-10110
UNIQUE constraint violation
-10199
Host variable type packed decimal is not supported
-10200
Reserved numeric operand found during data type conversion
-10201
Length error or incorrect value found during data type conversion
-10202
Division by zero attempted
-10203
Negative overflow occurred during data type conversion
-10204
Positive overflow occurred during data type conversion
-10205
Loss of significance occurred during data type conversion
-10207
Undefined value found during data type conversion
-10208
Restricted data type attribute violation
-10210
Error in assignment
-10211
Undefined value found during data type conversion
-10212
Overflow occurred during data type conversion
-10221
The NULL value cannot be assigned to a host variable because no indicator variable is specified
-10222
NULL not allowed for item descriptor area
-10250
Data type not supported
-10301
Loss of significance occurred in arithmetic operation <%>
-10302
Positive overflow occurred in arithmetic operation <%>
-10303
Negative overflow occurred in arithmetic operation <%>
-10304
Division by zero attempted
-10305
Bad parameter encountered in arithmetic operation <%>
-10306
Invalid input for numeric function
-10307
The binary strings are of unequal length
-10310
Invalid character value for CAST
-10311
String data truncated
-10312
Numeric value out of range
-10313
Illegal (negative) substring length
-10314
Like pattern escape character not followed by underscore or percent character
-10315
Length of like pattern escape character is not equal to 1
-10321
Datetime loss of significance
-10322
Datetime positive overflow
-10323
Datetime negative overflow
-10325
Bad parameter encountered in datetime operation
-10326
Datetime illegal operand
-10327
Invalid datetime value
-10328
Datetime subtype mismatch
-10329
Invalid datetime format
-10331
Interval loss of significance
-10332
Interval positive overflow
-10333
Interval negative overflow
-10335
Bad parameter encountered in interval operation
-10336
Interval illegal operand
-10337
Invalid interval value
-10338
Interval subtype mismatch
-10339
Invalid interval format
-10601
Invalid value for field of item descriptor area
-10602
Invalid datetime or interval code

Limits Exceeded

These errors arise when internal limits in the Mimer SQL system are exceeded. Some of the limitations are determined by installation-specific parameters, while others are fixed by Mimer SQL. In general, errors of this nature require either re-installation of the system with extended limitations or modification of the application program to reduce the system demands.

Contact your Mimer representative if you have difficulty avoiding errors of this nature.

Number
Explanation
-11001
Dynamic storage area exhausted in host level interface (DYNDE3)
-11002
Internal DB dynamic storage area (SQLPOOL) exhausted
-11011
Internal storage (SQLPOOL) for like pattern exhausted
-11012
Transaction list exhausted
-11013
Too many databanks referenced in statement (max 30)
-11014
Too many databanks active in transaction
-11047
The maximum number of recursive invocations has been exceeded
-11100
Internal limit exceeded : query stack
-11101
Internal limit exceeded : scan stack
-11102
Internal limit exceeded : generation stack
-11103
Internal limit exceeded : table descriptor list
-11105
Internal limit exceeded : patch table
-11106
Internal limit exceeded : label table
-11107
Internal limit exceeded : traversal stack
-11108
Internal limit exceeded : sco list
-11109
Internal limit exceeded : boolean stack
-11111
Internal limit exceeded : semantic stack
-11113
Internal limit exceeded : statement too complex
-11114
Required temporary table row length is <%>, only <%> is possible
-11115
Internal limit exceeded : restriction group pool
-11118
Internal limit exceeded : scan queue

SQL Statement Errors

These errors arise from syntactic or semantic errors in SQL statements. In general, syntactic errors in embedded SQL programs are detected by the preprocessor, so errors cannot arise at run-time.

Dynamically submitted SQL statements are however parsed at run-time, and the syntax error codes are returned after attempting PREPARE for a syntactically incorrect source statement.

Semantic errors can arise at run-time from both dynamic and static SQL statements.

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
-12120
Table name too long
-12121
String literal too long
-12122
Numeric literal too long
-12123
Invalid password string
-12124
Invalid hexadecimal literal
-12125
Reserved word may not be used as an identifier
-12126
Invalid name
-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
-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
-12220
Expression must be a column
-12221
SELECT clause contains both column expressions and set function expressions
-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
-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 <%>
-12236
Column name <%> does not identify a unique column of the result table
-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
-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
-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
Invalid datetime literal
-12281
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
-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
-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
-12523
Databank <%> does not exist
-12526
Default value for NOT NULL column <%> missing
-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)
-12542
Default value is outside the range specified by domain definition
-12544
Too many columns specified in <%> statement
-12545
Primary key column <%> may not be updated because the table is in a NULL 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 NULL 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 NULL option
-12551
Table <%> is in a databank with NULL option and may therefore not be used as referential constraint
-12553
Explicit grant membership on PUBLIC is not permitted
-12554
PUBLIC cannot be member of another group
-12556
<%> cannot be shadowed because it is a NULL 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
-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 data type for a column can not be changed to a domain
-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 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 UNIQUE constraint cannot be created because the columns contain duplicates
-12625
Referential constraint criteria not fulfilled
-12626
Check constraint criteria not fulfilled
-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
-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 <%> for a result set procedure must be declared as IN
-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
-12726
The formal argument of the routine is IN but the actual argument is OUT
-12727
The formal argument of the routine is OUT but the actual argument is IN
-12728
Literals or expressions cannot be used for OUT parameters
-12729
Return statements are only allowed in result set procedures or functions
-12730
Recursive call to <%>, not allowed
-12731
<%> statement not allowed in result procedure
-12732
The procedure <%> does not return a result set and cannot be used in a declare cursor for call
-12733
RESIGNAL statement only allowed in exception
-12734
Wrong number of items in result clause, <%> expected
-12735
Wrong number of parameters, <%> expected
-12736
Invalid type for argument, <%> expected
-12737
Too long name <%>
-12738
Duplicate declaration <%>
-12739
x.y.z names not allowed
-12740
Syntax error, <%> assumed to mean <%>
-12741
The label or routine <%> is not defined
-12742
The label <%> is not defined
-12743
The procedure <%> does not exist, (or no execute privilege)
-12744
The variable <%> is not defined
-12745
The condition identifier <%> is not defined
-12746
The cursor <%> is not defined
-12747
Use of domains in PSM control statements not allowed
-12748
Operands are incompatible
-12749
The SQL module <%> already exists
-12750
The procedure <%> already exists
-12751
Duplicate parameter <%>
-12752
The procedure <%> is declared in an SQL module, and cannot be dropped directly
-12753
Failed to read data dictionary
-12754
The length of a host variable cannot exceed 32
-12755
Host variables cannot be used within a procedure
-12756
The data type for the parameter marker cannot be determined
-12757
The number of items in the into clause is less than the number of items in the select list
-12758
The number of items in the into clause is greater than the number of items in the select list
-12759
The number of items in the fetch into clause is less than the number of items in the cursor declaration
-12760
The number of items in the fetch into clause is greater than the number of items in the cursor declaration
-12761
A fetch direction other than next, can only be defined for a scrollable cursor
-12762
The value in a fetch absolute or relative must be an integer
-12763
The argument to fetch absolute must be larger than 0
-12764
A cursor for call is read only and cannot be used in a update or delete where current statement
-12765
The cursor is declared as read only and cannot be used in a update or delete where current statement
-12766
The table name in the <%> statement is not the same as the name used in the cursor declaration
-12767
The column <%> is not specified in the for update list of the cursor declaration
-12768
The size for a data type must be larger than zero
-12769
It is not allowed to declare exception handlers or condition identifiers for the SQLSTATE successful completion ('00000')
-12770
The formal argument of the procedure is declared as INOUT but the actual argument is <%>
-12771
A handler declaration cannot contain both an exception class and SQLSTATE values or condition identifiers
-12772
The procedure does not return a result set and therefore cannot be used with a scroll cursor
-12773
<%> is not a column and is not declared as a variable or parameter
-12774
The label <%> has already been declared
-12775
The statement requires <%> access
-12776
<%> statement is only allowed if the access indication is MODIFIES SQL DATA or READS SQL DATA
-12777
<%> statements are only allowed if the access indication is MODIFIES SQL DATA
-12778
The access indication for a result set procedure must be READS SQL DATA or CONTAINS SQL
-12779
An UNDO exception handler can only be specified in an atomic compound statement
-12781
Only assignment and comparison operations allowed
-12782
The column name <%> has already occurred in this row declaration
-12783
The field <%> is not defined in the row data type
-12784
The row data types do not have the same number of fields
-12785
A row data type variable may not be used as a parameter or result type nor in a DML statement
-12800
Functionality not supported
-12801
Referencing OLD TABLE is not allowed if trigger event is INSERT
-12802
Referencing NEW TABLE is not allowed if trigger event is DELETE
-12803
The compound statement in a triggered action must be atomic
-12804
Referencing OLD or NEW ROW may only be used if FOR EACH ROW is specified
-12805
A column list can only be specified if trigger event is UPDATE
-12806
Duplicate column name in OF list
-12807
It is not allowed to modify the <%> table
-12808
The trigger time for a view must be INSTEAD OF
-12809
The trigger time for a base table can not be INSTEAD OF
-12810
Only the creator of a table is allowed to create a trigger for the table
-12811
It is not allowed to create triggers for tables, located in databanks with NULL option
-12812
Referencing OLD or NEW table is not allowed in FOR EACH ROW triggers
-12813
A trigger with the name <%> already exists
-12830
A function with the name <%> already exists
-12831
The function <%> does not exist, (or no execute privilege)
-12832
The result of the expression is not deterministic while the routine is declared as deterministic
-12833
All privileges used in a trigger must be held with grant option
-12834
The sequence <%> does not exist
-12835
A sequence with the name <%> already exists
-12836
The keyword NULL cannot be used <%>
-12837
The operands to a overlaps predicate must be of a row data type with two elements
-12838
The two elements in an operand to the overlaps predicate must either be of the same type or otherwise it shall be possible to add the second value to first value
-12839
<%> is not allowed in a before trigger
-12840
The simple value specification for a get diagnostics statement must be of integer type
-12841
<%> is not allowed in a trigger
-12842
The increment for a sequence must be non zero
-12843
Invalid values for sequence attributes
-12844
The schema <%> does not exist, (or no privilege)
-12845
The schema name for routines in a module definition must be the same as the schema name for the module
-12846
The value for diagnostics size must be positive
-12847
The ident name in an authorization clause must be the same as the current user
-12848
Constraint name already exists
-12849
The function <%> MODIFIES SQL DATA and can thus not be used in a DML statement
-12850
A trigger must be located in the same schema as the table
-12851
A constraint must have the same schema name as the object to which it belongs
-12852
The schema name for a routine is not the same as the schema name for the module
-12853
Ident name not allowed as a schema with the same name exists
-12854
A non-deterministic expression is not allowed in a check clause
-12855
Default values with a reference to a sequence combined with a check clause is not allowed in an alter table statement

Program-dependent Errors

These errors arise as a result of incorrect program construction. In general, corrective action requires revision of the program source code.

</
Number
Explanation
-14001
Invalid sequence of SQL statements
-14002
SQL statement invalid because the user is not connected
-14003
CONNECT statement invalid because the user is already connected
-14004
System already closed down
-14005
Cannot perform DISCONNECT in a transaction
-14006
Login failure
-14011
Transaction already started
-14012
Transaction handling required
-14013
No transaction started
-14014
Cannot perform write operations as transaction status is read-only
-14015
Commit or rollback statements are not allowed in an atomic execution context
-14016
Select for update is not allowed for a read-only cursor
-14017
Mixing DDL and DML statements in a transaction is not allowed
-14018
Incremental backup not allowed in BACKUP transaction
-14019
Operation not allowed in BACKUP transaction
-14020
START BACKUP command required to perform an online backup
-14021
Cannot perform ENTER or LEAVE in a transaction
-14022
Cannot perform ENTER operation because program level is already active
-14023
No program level entered, cannot perform leave operation
-14024
Session statements are not allowed in a trigger
-14031
DESCRIBE statement does not identify a prepared statement
-14032
EXECUTE statement does not identify a prepared statement
-14033
PREPARE statement identifies a SELECT statement of an opened cursor
-14034
The cursor is not in a prepared state
-14035
The cursor identified in a FETCH or CLOSE statement is not open
-14036
The cursor cannot be used because its statement name does not identify a prepared SELECT statement
-14037
The cursor identified in the UPDATE or DELETE statement is not open
-14038
UPDATE or DELETE CURRENT statement not allowed for a cursor of a prepared SELECT statement
-14039
Cursor is not scrollable
-14041
The cursor identified in the UPDATE statement is not positioned on a row
-14042
The cursor identified in the DELETE statement is not positioned on a row
-14043
Routine signaled SQLSTATE
-14044
Routine signaled a condition
-14045
Prepared statement not a cursor specification
-14046
The statement RESIGNAL was used outside a exception handler
-14101
Invalid statement identifier
-14201
Compilation did not yield an executable program
-14202
The cursor identified in an OPEN statement is already open, but not declared as REOPENABLE
-14203
Statement position cannot be saved when temporary tables are used in the query
-14210
Cursor for result set procedure may not be reopenable
-14211
With hold option is not available for result set procedures