Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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 Documentation TOC PREV NEXT INDEX