Mimer SQL Programmer's 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 the status of an SQL statement. These return codes are standardized following 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.

The following table lists SQLSTATE values:

Class
Subclass
Meaning
00
000
Success
01
000
Success with 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
02
000
No data
07
000
Dynamic SQL error
07
001
using-clause does not match dynamic variables
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
006
Restricted data type attribute violation
07
007
using-clause required for result fields
07
008
Invalid descriptor count
07
009
Invalid descriptor index
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
0A
000
Feature not supported
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 variable
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
027
Trim error
23
000
Integrity constraint violation
24
000
Invalid cursor state
25
000
Invalid transaction state
26
000
Invalid SQL statement identifier
28
000
Invalid authorization specification
2E
000
Invalid connection name
33
000
Invalid SQL descriptor name
34
000
Invalid cursor name
35
000
Invalid exception number
37
000
Syntax error or access violation in
PREPARE or EXECUTE IMMEDIATE
3C
000
Ambiguous cursor name
40
000
Transaction rollback
40
001
Serialization failure
40
003
Statement completion unknown
42
000
Syntax error or access violation
44
000
WITH CHECK OPTION violation
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 Programmer's Manual TOC PREV NEXT INDEX