Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


SQLSTATE Return Codes


SQLSTATE contains a 5 character long return code string that indicates status of an SQL statement. These return codes follows the established standards. Observe that not all standardized SQLSTATE return codes are used by Mimer SQL.

The SQLSTATE values consists of two fields: the class, which is the first two characters of the string, and the subclass, which is the terminating three characters of the string.

List of SQLSTATE Values

:
Class
Subclass
Meaning
00
000
Successful completion
01
000
Warning
01
002
Disconnect error
01
003
Null value eliminated in set function
01
004
String data, right truncation
01
005
Insufficient item descriptor areas
01
006
Privilege not revoked
01
007
Privilege not granted
01
008
Implicit zero-bit padding
01
009
Search condition too long for information schema
01
00A
Query expression too long for information schema
01
00B
Default option too long for information schema
02
000
No data
07
000
Dynamic SQL error
07
001
using clause does not match dynamic parameter specifications
07
002
using clause does not match target specification
07
003
Cursor specification cannot be executed
07
004
using clause required for dynamic parameters
07
005
Prepared statement is not a cursor specification
07
006
Restricted data type attribute violation
07
007
using clause required for result fields
07
008
Invalid descriptor count
07
009
Invalid descriptor index
07
00F
Undefined DATETIME_INTERVAL_CODE
08
000
Connection exception
08
001
Client unable to establish connection
08
002
Connection name in use
08
003
Connection does not exist
08
004
Server rejected the connection
08
006
Connection failure
09
000
Triggered action exception
0A
000
Feature not supported
0K
000
Resignal when handler not active
20
000
Case not found for a case statement
21
000
Cardinality violation
22
000
Data exception
22
001
String data, right truncation
22
002
Null value, no indicator parameter
22
003
Numeric value out of range
22
005
Error in assignment
22
006
Invalid interval format
22
007
Invalid datetime format
22
008
Datetime field overflow
22
011
Substring error
22
012
Division by zero
22
015
Interval field overflow
22
018
Invalid character value for cast
22
019
Invalid escape character
22
023
Invalid parameter value
22
024
Unterminated C string
22
025
Invalid escape sequence
22
026
String data, length mismatch
22
027
Trim error
23
000
Integrity constraint violation
24
000
Invalid cursor state
25
000
Invalid transaction state
26
000
Invalid SQL statement name
27
000
Triggered data change violation
28
000
Invalid authorization specification
2E
000
Invalid connection name
2F
000
SQL routine exception
2F
003
Prohibited SQL-statement attempted
2F
005
Function executed no return statement
33
000
Invalid SQL descriptor name
34
000
Invalid cursor name
35
000
Invalid condition number
3C
000
Ambiguous cursor name
40
000
Transaction rollback
40
001
Serialization failure
40
003
Statement completion unknown
42
000
Syntax error or access rule violation
44
000
WITH CHECK OPTION violation
45
000
Unhandled user-defined exception
S1
000
General error
S1
001
Memory allocation failure



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX