SQL Communication Area › SQLSTATE Values

SQLSTATE Values

The list of SQLSTATE values that CA IDMS can return appears next. The list is divided into sections based on the class (the first 2 characters of the SQLSTATE value). Each subclass (the last 3 characters of the SQLSTATE value) is listed under its associated class.

Standard -defined Values

Class and subclass values beginning with the characters A-H and 0-4 are established by the SQL standard organizations.

CA IDMS-defined Values

Class and subclass values beginning with the characters I-Z and 5-9 are vendor-defined; in this case, they are specific to CA IDMS. Any subclass value associated with a vendor-defined class is also defined by that vendor.

SQLSTATE Values

      00 Successful completion
         000  No subclass

      01 Warning
         000  No subclass
         004  String data, right truncation
         00C  SQL-invoked procedure returned result sets
         00D  Additional result sets returned
         00E  Attempt to return too many result sets
         010  Column cannot be mapped
         600  Inconsistent or invalid option
         602  Entity or association already exists
         605  Entity not defined in Catalog
         606  Invalid option for physical DDL
         607  Invalid option for DMCL
         608  Connecting to a dictionary which is missing either or
              or both of DDLCAT/DDLDML areas
         610  Database is inconsistent with request
         611  SQL routine parse error
         612  ADS compilation for an SQL routine failed
         613  Drop of SQL routine completed with warnings
         638  Warning returned from table procedure

      02 No data
         000  No subclass

      07 Dynamic SQL error
         000 No subclass
         001 USING clause does not match dynamic parameter specification
         002 USING clause does not match target specification
         003 Cursor specification cannot be executed
         004 USING clause required for dynamic parameters

      08 Connection exception
         000  No subclass
         004  SQL-server rejected establishment of SQL-connection
         006  Connection failure

      0M Invalid SQL-invoked procedure reference
         000  No subclass

      0N SQL/XML Mapping Error
         000  No subclass
         001  Unmappable XML name
         002  Invalid XML character

      21 Cardinality violation
         000  No subclass

      22 Data Exception
         000  No subclass
         001  String data, right truncation
         002  Null value, no indicator parameter
         003  Numeric value out of range
         005  Error in assignment
         007  Invalid datetime format
         008  Datetime field overflow
         00J  Nonidentical notations with the same name
         00K  Nonidentical unparsed entities with the same name
         00L  Not an XML document
         00M  Invalid XML document
         00N  Invalid XML content
         00R  XML value overflow
         00S  Invalid comment
         00T  Invalid processing instruction
         011  Substring error
         012  Division by zero
         019  Invalid escape character

      23 Constraint violation
         000  No subclass
         501  Duplicate key violation

      24 Invalid cursor state
         000  No subclass

      25 Invalid transaction state
         000  No subclass
         006  Read-only SQL-transaction

      26 Invalid SQL statement name
         000  No subclass

      28 Invalid authorization specification
         000  No subclass
         602  Entity or association already defined
         605  Entity or association not previously defined
         607  Authorization ids not specified

      2C Invalid character set name
         000  No subclass

      34 Invalid cursor name
         000  No subclass

      37 Syntax error or access rule violation
         000  No subclass

      38 External routine exception
         000  No subclass
         999  ADS dialog failed or dialog does not exist

      39 External routine invocation exception
         000  No subclass

      3F Invalid schema name
         000  No subclass

      40 Transaction rollback
         000  No subclass
         001  Serialization failure

      42 Syntax error or access rule violation
         000  No subclass
         500  Table not found
         501  Column not found
         502  Entity already defined
         503  Authorization failure
         504  Cursor not declared or previously declared
         505  Entity not found
         506  Invalid identifier
         507  Keyword used as identifier
         600  Invalid statement
         601  Statement not valid in this context
         603  Statement not valid for this schema
         604  Invalid data type
         606  Invalid statement option
         607  Missing statement option
         609  Invalid constraint definition
         610  Invalid number of columns

      50 CA-defined errors
         000  No subclass
         002  Limit exceeded
         003  Space exceeded
         00B  Internal error
         00I  Schema mismatch
         00J  Invalid entity definition
         00K  Uncategorized error
         00L  Invalid calling parameters

      60 CA IDMS specific errors
         000  No subclass
         001  Problem with load module or synchronization stamps
         002  Database error
         003  Rollback failed
         004  Failure while opening or describing a received cursor
         005  Unexpected error from GET/PUT SCRATCH

      64 CA IDMS Physical DDL error
         000  No subclass

      6U CA IDMS Utility error
         000  No subclass