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 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
 08
 S01 
 Communication link 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
 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