Content deleted Content added
Changing interwiki redirect to b:en:Structured Query Language/SQLSTATE into a soft redirect. If this bot is malfunctioning, please report it at User:AnomieBOT III/shutoff/BrokenRedirectDeleter |
Working citation to SQL-2011 added |
||
| (15 intermediate revisions by 10 users not shown) | |||
Line 1:
Programs calling a database that accords to the [[SQL]] standard receive an indication of the success or failure of the call. This return code - which is called SQLSTATE - consists of 5 bytes. They are divided into two parts: the first and second bytes contain a '''class''' and the following three a '''subclass'''. Each class belongs to one of four '''categories''': "S" denotes "Success" (class 00), "W" denotes "Warning" (class 01), "N" denotes "No data" (class 02), and "X" denotes "Exception" (all other classes).
* Real DBMSs are free to define additional values for SQLSTATE to handle those features that are beyond the standard. Such values must use one of the characters [I-Z] or [5-9] as the first byte of class (first byte of SQLSTATE) or subclass (third byte of SQLSTATE).
* In addition to SQLSTATE the SQL command <code>GET DIAGNOSTICS</code> offers more details about the last executed SQL command.
* In very early versions of the SQL standard the return code was called SQLCODE and used a different coding schema.
The following table lists the standard-conforming values - based on [[SQL:2011]].<ref name="Whitemarsh2" /> The table's last column shows the part of the standard that defines the row. If it is empty, the definition originates from part 2 ''Foundation''.
{|class="wikitable"
! SQLSTATE !!Cat.!!Class!! style="text-align:left" | Class Text !!Subclass!! style="text-align:left" | Subclass Text !! SQL part
|-
| {{mono|00000}} || S || 00 || successful completion || 000 || {{CNone|(no subclass)}} ||
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|01000}} || W || 01 || warning || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|01001}} || W || 01 || warning || 001 || cursor operation conflict ||
|-
| {{mono|01002}} || W || 01 || warning || 002 || disconnect error ||
|-
| {{mono|01003}} || W || 01 || warning || 003 || null value eliminated in set function ||
|-
| {{mono|01004}} || W || 01 || warning || 004 || string data, right truncation ||
|-
| {{mono|01005}} || W || 01 || warning || 005 || insufficient item descriptor areas ||
|-
| {{mono|01006}} || W || 01 || warning || 006 || privilege not revoked ||
|-
| {{mono|01007}} || W || 01 || warning || 007 || privilege not granted ||
|-
| {{mono|01009}} || W || 01 || warning || 009 || search condition too long for information schema ||
|-
| {{mono|0100A}} || W || 01 || warning || 00A || query expression too long for information schema ||
|-
| {{mono|0100B}} || W || 01 || warning || 00B || default value too long for information schema ||
|-
| {{mono|0100C}} || W || 01 || warning || 00C || result sets returned ||
|-
| {{mono|0100D}} || W || 01 || warning || 00D || additional result sets returned ||
|-
| {{mono|0100E}} || W || 01 || warning || 00E || attempt to return too many result sets ||
|-
| {{mono|0100F}} || W || 01 || warning || 00F || statement too long for information schema ||
|-
| {{mono|01010}} || W || 01 || warning || 010 || column cannot be mapped || [[SQL/XML]]
|-
| {{mono|01011}} || W || 01 || warning || 011 || SQL-Java path too long for information schema || [[SQL/JRT]]
|-
| {{mono|01012}} || W || 01 || warning || 012 || invalid number of conditions ||
|-
| {{mono|0102F}} || W || 01 || warning || 02F || array data, right truncation ||
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|02000}} || N || 02 || no data || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|02001}} || N || 02 || no data || 001 || no additional result sets returned ||
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|07000}} || X || 07 || dynamic SQL error || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|07001}} || X || 07 || dynamic SQL error || 001 || using clause does not match dynamic parameter specifications ||
|-
| {{mono|07002}} || X || 07 || dynamic SQL error || 002 || using clause does not match target specifications ||
|-
| {{mono|07003}} || X || 07 || dynamic SQL error || 003 || cursor specification cannot be executed ||
|-
| {{mono|07004}} || X || 07 || dynamic SQL error || 004 || using clause required for dynamic parameters ||
|-
| {{mono|07005}} || X || 07 || dynamic SQL error || 005 || prepared statement not a cursor specification ||
|-
| {{mono|07006}} || X || 07 || dynamic SQL error || 006 || restricted data type attribute violation ||
|-
| {{mono|07007}} || X || 07 || dynamic SQL error || 007 || using clause required for result fields ||
|-
| {{mono|07008}} || X || 07 || dynamic SQL error || 008 || invalid descriptor count ||
|-
| {{mono|07009}} || X || 07 || dynamic SQL error || 009 || invalid descriptor index ||
|-
| {{mono|0700B}} || X || 07 || dynamic SQL error || 00B || data type transform function violation ||
|-
| {{mono|0700C}} || X || 07 || dynamic SQL error || 00C || undefined DATA value ||
|-
| {{mono|0700D}} || X || 07 || dynamic SQL error || 00D || invalid DATA target ||
|-
| {{mono|0700E}} || X || 07 || dynamic SQL error || 00E || invalid LEVEL value ||
|-
| {{mono|0700F}} || X || 07 || dynamic SQL error || 00F || invalid DATETIME_INTERVAL_CODE ||
|-
| {{mono|08000}} || X || 08 || connection exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|08001}} || X || 08 || connection exception || 001 || SQL-client unable to establish SQL-connection ||
|-
| {{mono|08002}} || X || 08 || connection exception || 002 || connection name in use ||
|-
| {{mono|08003}} || X || 08 || connection exception || 003 || connection does not exist ||
|-
| {{mono|08004}} || X || 08 || connection exception || 004 || SQL-server rejected establishment of SQL-connection ||
|-
| {{mono|08006}} || X || 08 || connection exception || 006 || connection failure ||
|-
| {{mono|08007}} || X || 08 || connection exception || 007 || transaction resolution unknown ||
|-
| {{mono|09000}} || X || 09 || triggered action exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0A000}} || X || 0A || feature not supported || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0A001}} || X || 0A || feature not supported || 001 || multiple server transactions ||
|-
| {{mono|0D000}} || X || 0D || invalid target type specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0E000}} || X || 0E || invalid schema name list specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0F000}} || X || 0F || locator exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0F001}} || X || 0F || locator exception || 001 || invalid specification ||
|-
| {{mono|0K000}} || X || 0K || resignal when handler not active || 000 || {{CNone|(no subclass)}} || [[SQL/PSM]]
|-
| {{mono|0L000}} || X || 0L || invalid grantor || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0M000}} || X || 0M || invalid SQL-invoked procedure reference || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0N000}} || X || 0N || SQL/XML mapping error || 000 || {{CNone|(no subclass)}} || [[SQL/XML]]
|-
| {{mono|0N001}} || X || 0N || SQL/XML mapping error || 001 || unmappable XML name || [[SQL/XML]]
|-
| {{mono|0N002}} || X || 0N || SQL/XML mapping error || 002 || invalid XML character || [[SQL/XML]]
|-
| {{mono|0P000}} || X || 0P || invalid role specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0S000}} || X || 0S || invalid transform group name specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0T000}} || X || 0T || target table disagrees with cursor specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0U000}} || X || 0U || attempt to assign to non-updatable column || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0V000}} || X || 0V || attempt to assign to ordering column || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0W000}} || X || 0W || prohibited statement encountered during trigger execution || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0W001}} || X || 0W || prohibited statement encountered during trigger execution || 001 || modify table modified by data change delta table ||
|-
| {{mono|0X000}} || X || 0X || invalid foreign server specification || 000 || {{CNone|(no subclass)}} || [[SQL/MED]]
|-
| {{mono|0Y000}} || X || 0Y || pass-through specific condition || 000 || {{CNone|(no subclass)}} || [[SQL/MED]]
|-
| {{mono|0Y001}} || X || 0Y || pass-through specific condition || 001 || invalid cursor option || [[SQL/MED]]
|-
| {{mono|0Y002}} || X || 0Y || pass-through specific condition || 002 || invalid cursor allocation || [[SQL/MED]]
|-
| {{mono|0Z000}} || X || 0Z || diagnostics exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|0Z001}} || X || 0Z || diagnostics exception || 001 || maximum number of stacked diagnostics areas exceeded ||
|-
| {{mono|0Z002}} || X || 0Z || diagnostics exception || 002 || stacked diagnostics accessed without active handler || [[SQL/PSM]]
|-
| {{mono|10000}} || X || 10 || XQuery error || 000 || {{CNone|(no subclass)}} || [[SQL/XML]]
|-
| {{mono|20000}} || X || 20 || case not found for case statement || 000 || {{CNone|(no subclass)}} || [[SQL/PSM]]
|-
| {{mono|21000}} || X || 21 || cardinality violation || 000 || {{CNone|(no subclass)}} ||
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|22000}} || X || 22 || data exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|22001}} || X || 22 || data exception || 001 || string data, right truncation ||
|-
| {{mono|22002}} || X || 22 || data exception || 002 || null value, no indicator parameter ||
|-
| {{mono|22003}} || X || 22 || data exception || 003 || numeric value out of range ||
|-
| {{mono|22004}} || X || 22 || data exception || 004 || null value not allowed ||
|-
| {{mono|22005}} || X || 22 || data exception || 005 || error in assignment ||
|-
| {{mono|22006}} || X || 22 || data exception || 006 || invalid interval format ||
|-
| {{mono|22007}} || X || 22 || data exception || 007 || invalid datetime format ||
|-
| {{mono|22008}} || X || 22 || data exception || 008 || datetime field overflow ||
|-
| {{mono|22009}} || X || 22 || data exception || 009 || invalid time zone displacement value ||
|-
| {{mono|2200B}} || X || 22 || data exception || 00B || escape character conflict ||
|-
| {{mono|2200C}} || X || 22 || data exception || 00C || invalid use of escape character ||
|-
| {{mono|2200D}} || X || 22 || data exception || 00D || invalid escape octet ||
|-
| {{mono|2200E}} || X || 22 || data exception || 00E || null value in array target ||
|-
| {{mono|2200F}} || X || 22 || data exception || 00F || zero-length character string ||
|-
| {{mono|2200G}} || X || 22 || data exception || 00G || most specific type mismatch ||
|-
| {{mono|2200H}} || X || 22 || data exception || 00H || sequence generator limit exceeded ||
|-
| {{mono|2200J}} || X || 22 || data exception || 00J || nonidentical notations with the same name || [[SQL/XML]]
|-
| {{mono|2200K}} || X || 22 || data exception || 00K || nonidentical unparsed entities with the same name || [[SQL/XML]]
|-
| {{mono|2200L}} || X || 22 || data exception || 00L || not an XML document || [[SQL/XML]]
|-
| {{mono|2200M}} || X || 22 || data exception || 00M || invalid XML document || [[SQL/XML]]
|-
| {{mono|2200N}} || X || 22 || data exception || 00N || invalid XML content || [[SQL/XML]]
|-
| {{mono|2200P}} || X || 22 || data exception || 00P || interval value out of range ||
|-
| {{mono|2200Q}} || X || 22 || data exception || 00Q || multiset value overflow ||
|-
| {{mono|2200R}} || X || 22 || data exception || 00R || XML value overflow || [[SQL/XML]]
|-
| {{mono|2200S}} || X || 22 || data exception || 00S || invalid comment || [[SQL/XML]]
|-
| {{mono|2200T}} || X || 22 || data exception || 00T || invalid processing instruction || [[SQL/XML]]
|-
| {{mono|2200U}} || X || 22 || data exception || 00U || not an XQuery document node || [[SQL/XML]]
|-
| {{mono|2200V}} || X || 22 || data exception || 00V || invalid XQuery context item || [[SQL/XML]]
|-
| {{mono|2200W}} || X || 22 || data exception || 00W || XQuery serialization error || [[SQL/XML]]
|-
| {{mono|22010}} || X || 22 || data exception || 010 || invalid indicator parameter value ||
|-
| {{mono|22011}} || X || 22 || data exception || 011 || substring error ||
|-
| {{mono|22012}} || X || 22 || data exception || 012 || division by zero ||
|-
| {{mono|22013}} || X || 22 || data exception || 013 || invalid preceding or following size in window function ||
|-
| {{mono|22014}} || X || 22 || data exception || 014 || invalid argument for NTILE function ||
|-
| {{mono|22015}} || X || 22 || data exception || 015 || interval field overflow ||
|-
| {{mono|22016}} || X || 22 || data exception || 016 || invalid argument for NTH_VALUE function ||
|-
| {{mono|22017}} || X || 22 || data exception || 017 || invalid data specified for datalink || [[SQL/MED]]
|-
| {{mono|22018}} || X || 22 || data exception || 018 || invalid character value for cast ||
|-
| {{mono|22019}} || X || 22 || data exception || 019 || invalid escape character ||
|-
| {{mono|2201A}} || X || 22 || data exception || 01A || null argument passed to datalink constructor || [[SQL/MED]]
|-
| {{mono|2201B}} || X || 22 || data exception || 01B || invalid regular expression ||
|-
| {{mono|2201C}} || X || 22 || data exception || 01C || null row not permitted in table ||
|-
| {{mono|2201D}} || X || 22 || data exception || 01D || datalink value exceeds maximum length || [[SQL/MED]]
|-
| {{mono|2201E}} || X || 22 || data exception || 01E || invalid argument for natural logarithm ||
|-
| {{mono|2201F}} || X || 22 || data exception || 01F || invalid argument for power function ||
|-
| {{mono|2201G}} || X || 22 || data exception || 01G || invalid argument for width bucket function ||
|-
| {{mono|2201H}} || X || 22 || data exception || 01H || invalid row version ||
|-
| {{mono|2201J}} || X || 22 || data exception || 01J || XQuery sequence cannot be validated || [[SQL/XML]]
|-
| {{mono|2201K}} || X || 22 || data exception || 01K || XQuery document node cannot be validated || [[SQL/XML]]
|-
| {{mono|2201L}} || X || 22 || data exception || 01L || no XML schema found || [[SQL/XML]]
|-
| {{mono|2201M}} || X || 22 || data exception || 01M || element namespace not declared || [[SQL/XML]]
|-
| {{mono|2201N}} || X || 22 || data exception || 01N || global element not declared || [[SQL/XML]]
|-
| {{mono|2201P}} || X || 22 || data exception || 01P || no XML element with the specified QName || [[SQL/XML]]
|-
| {{mono|2201Q}} || X || 22 || data exception || 01Q || no XML element with the specified namespace || [[SQL/XML]]
|-
| {{mono|2201R}} || X || 22 || data exception || 01R || validation failure || [[SQL/XML]]
|-
| {{mono|2201S}} || X || 22 || data exception || 01S || invalid Query regular expression ||
|-
| {{mono|2201T}} || X || 22 || data exception || 01T || invalid Query option flag ||
|-
| {{mono|2201U}} || X || 22 || data exception || 01U || attempt to replace a zero-length string ||
|-
| {{mono|2201V}} || X || 22 || data exception || 01V || invalid Query replacement string ||
|-
| {{mono|2201W}} || X || 22 || data exception || 01W || invalid row count in fetch first clause ||
|-
| {{mono|2201X}} || X || 22 || data exception || 01X || invalid row count in result offset clause ||
|-
| {{mono|22021}} || X || 22 || data exception || 021 || character not in repertoire ||
|-
| {{mono|22022}} || X || 22 || data exception || 022 || indicator overflow ||
|-
| {{mono|22023}} || X || 22 || data exception || 023 || invalid parameter value ||
|-
| {{mono|22024}} || X || 22 || data exception || 024 || unterminated C string ||
|-
| {{mono|22025}} || X || 22 || data exception || 025 || invalid escape sequence ||
|-
| {{mono|22026}} || X || 22 || data exception || 026 || string data, length mismatch ||
|-
| {{mono|22027}} || X || 22 || data exception || 027 || trim error ||
|-
| {{mono|22029}} || X || 22 || data exception || 029 || noncharacter in UCS string ||
|-
| {{mono|2202A}} || X || 22 || data exception || 02A || null value in field reference || [[SQL/PSM]]
|-
| {{mono|2202D}} || X || 22 || data exception || 02D || null value substituted for mutator subject parameter ||
|-
| {{mono|2202E}} || X || 22 || data exception || 02E || array element error ||
|-
| {{mono|2202F}} || X || 22 || data exception || 02F || array data, right truncation ||
|-
| {{mono|2202G}} || X || 22 || data exception || 02G || invalid repeat argument in a sample clause ||
|-
| {{mono|2202H}} || X || 22 || data exception || 02H || invalid sample size ||
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|23000}} || X || 23 || integrity constraint violation || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|23001}} || X || 23 || integrity constraint violation || 001 || restrict violation ||
|-
| {{mono|24000}} || X || 24 || invalid cursor state || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|25000}} || X || 25 || invalid transaction state || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|25001}} || X || 25 || invalid transaction state || 001 || active SQL-transaction ||
|-
| {{mono|25002}} || X || 25 || invalid transaction state || 002 || branch transaction already active ||
|-
| {{mono|25003}} || X || 25 || invalid transaction state || 003 || inappropriate access mode for branch transaction ||
|-
| {{mono|25004}} || X || 25 || invalid transaction state || 004 || inappropriate isolation level for branch transaction ||
|-
| {{mono|25005}} || X || 25 || invalid transaction state || 005 || no active SQL-transaction for branch transaction ||
|-
| {{mono|25006}} || X || 25 || invalid transaction state || 006 || read-only SQL-transaction ||
|-
| {{mono|25007}} || X || 25 || invalid transaction state || 007 || schema and data statement mixing not supported ||
|-
| {{mono|25008}} || X || 25 || invalid transaction state || 008 || held cursor requires same isolation level ||
|-
| {{mono|26000}} || X || 26 || invalid SQL statement name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|27000}} || X || 27 || triggered data change violation || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|27001}} || X || 27 || triggered data change violation || 001 || modify table modified by data change delta table ||
|-
| {{mono|28000}} || X || 28 || invalid authorization specification || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2B000}} || X || 2B || dependent privilege descriptors still exist || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2C000}} || X || 2C || invalid character set name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2D000}} || X || 2D || invalid transaction termination || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2E000}} || X || 2E || invalid connection name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2F000}} || X || 2F || SQL routine exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|2F002}} || X || 2F || SQL routine exception || 002 || modifying SQL-data not permitted ||
|-
| {{mono|2F003}} || X || 2F || SQL routine exception || 003 || prohibited SQL-statement attempted ||
|-
| {{mono|2F004}} || X || 2F || SQL routine exception || 004 || reading SQL-data not permitted ||
|-
| {{mono|2F005}} || X || 2F || SQL routine exception || 005 || function executed no return statement ||
|-
| {{mono|2H000}} || X || 2H || invalid collation name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|30000}} || X || 30 || invalid SQL statement identifier || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|33000}} || X || 33 || invalid SQL descriptor name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|34000}} || X || 34 || invalid cursor name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|35000}} || X || 35 || invalid condition number || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|36000}} || X || 36 || cursor sensitivity exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|36001}} || X || 36 || cursor sensitivity exception || 001 || request rejected ||
|-
| {{mono|36002}} || X || 36 || cursor sensitivity exception || 002 || request failed ||
|-
| {{mono|38000}} || X || 38 || external routine exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|38001}} || X || 38 || external routine exception || 001 || containing SQL not permitted ||
|-
| {{mono|38002}} || X || 38 || external routine exception || 002 || modifying SQL-data not permitted ||
|-
| {{mono|38003}} || X || 38 || external routine exception || 003 || prohibited SQL-statement attempted ||
|-
| {{mono|38004}} || X || 38 || external routine exception || 004 || reading SQL-data not permitted ||
|-
| {{mono|39000}} || X || 39 || external routine invocation exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|39004}} || X || 39 || external routine invocation exception || 004 || null value not allowed ||
|-
| {{mono|3B000}} || X || 3B || savepoint exception || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|3B001}} || X || 3B || savepoint exception || 001 || invalid specification ||
|-
| {{mono|3B002}} || X || 3B || savepoint exception || 002 || too many ||
|-
| {{mono|3C000}} || X || 3C || ambiguous cursor name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|3D000}} || X || 3D || invalid catalog name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|3F000}} || X || 3F || invalid schema name || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|40000}} || X || 40 || transaction rollback || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|40001}} || X || 40 || transaction rollback || 001 || serialization failure ||
|-
| {{mono|40002}} || X || 40 || transaction rollback || 002 || integrity constraint violation ||
|-
| {{mono|40003}} || X || 40 || transaction rollback || 003 || statement completion unknown ||
|-
| {{mono|40004}} || X || 40 || transaction rollback || 004 || triggered action exception ||
|-
| {{mono|42000}} || X || 42 || syntax error or access rule violation || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|44000}} || X || 44 || with check option violation || 000 || {{CNone|(no subclass)}} ||
|-
| {{mono|45000}} || X || 45 || unhandled user-defined exception || 000 || {{CNone|(no subclass)}} || [[SQL/PSM]]
|-
| {{mono|46000}} || X || 46 || OLB-specific error || 000 || {{CNone|(no subclass)}} || [[SQL/OLB]]
|-
| {{mono|46001}} || X || 46 || Java DDL || 001 || invalid URL || [[SQL/JRT]]
|-
| {{mono|46002}} || X || 46 || Java DDL || 002 || invalid JAR name || [[SQL/JRT]]
|-
| {{mono|46003}} || X || 46 || Java DDL || 003 || invalid class deletion || [[SQL/JRT]]
|-
| {{mono|46005}} || X || 46 || Java DDL || 005 || invalid replacement || [[SQL/JRT]]
|-
| {{mono|4600A}} || X || 46 || Java DDL || 00A || attempt to replace uninstalled JAR || [[SQL/JRT]]
|-
| {{mono|4600B}} || X || 46 || Java DDL || 00B || attempt to remove uninstalled JAR || [[SQL/JRT]]
|-
| {{mono|4600C}} || X || 46 || Java DDL || 00C || invalid JAR removal || [[SQL/JRT]]
|-
| {{mono|4600D}} || X || 46 || Java DDL || 00D || invalid path || [[SQL/JRT]]
|-
| {{mono|4600E}} || X || 46 || Java DDL || 00E || self-referencing path || [[SQL/JRT]]
|-
| {{mono|46102}} || X || 46 || Java DDL || 102 || invalid JAR name in path || [[SQL/JRT]]
|-
| {{mono|46103}} || X || 46 || Java DDL || 103 || unresolved class name || [[SQL/JRT]]
|-
| {{mono|46110}} || X || 46 || OLB-specific error || 110 || unsupported feature || [[SQL/OLB]]
|-
| {{mono|46120}} || X || 46 || OLB-specific error || 120 || invalid class declaration || [[SQL/OLB]]
|-
| {{mono|46121}} || X || 46 || OLB-specific error || 121 || invalid column name || [[SQL/OLB]]
|-
| {{mono|46122}} || X || 46 || OLB-specific error || 122 || invalid number of columns || [[SQL/OLB]]
|-
| {{mono|46130}} || X || 46 || OLB-specific error || 130 || invalid profile state || [[SQL/OLB]]
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|HW000}} || X || HW || datalink exception || 000 || {{CNone|(no subclass)}} || [[SQL/MED]]
|-
| {{mono|HW001}} || X || HW || datalink exception || 001 || external file not linked || [[SQL/MED]]
|-
| {{mono|HW002}} || X || HW || datalink exception || 002 || external file already linked || [[SQL/MED]]
|-
| {{mono|HW003}} || X || HW || datalink exception || 003 || referenced file does not exist || [[SQL/MED]]
|-
| {{mono|HW004}} || X || HW || datalink exception || 004 || invalid write token || [[SQL/MED]]
|-
| {{mono|HW005}} || X || HW || datalink exception || 005 || invalid datalink construction || [[SQL/MED]]
|-
| {{mono|HW006}} || X || HW || datalink exception || 006 || invalid write permission for update || [[SQL/MED]]
|-
| {{mono|HW007}} || X || HW || datalink exception || 007 || referenced file not valid || [[SQL/MED]]
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|HV000}} || X || HV || FDW-specific condition || 000 || {{CNone|(no subclass)}} || [[SQL/MED]]
|-
| {{mono|HV001}} || X || HV || FDW-specific condition || 001 || memory allocation error || [[SQL/MED]]
|-
| {{mono|HV002}} || X || HV || FDW-specific condition || 002 || dynamic parameter value needed || [[SQL/MED]]
|-
| {{mono|HV004}} || X || HV || FDW-specific condition || 004 || invalid data type || [[SQL/MED]]
|-
| {{mono|HV005}} || X || HV || FDW-specific condition || 005 || column name not found || [[SQL/MED]]
|-
| {{mono|HV006}} || X || HV || FDW-specific condition || 006 || invalid data type descriptors || [[SQL/MED]]
|-
| {{mono|HV007}} || X || HV || FDW-specific condition || 007 || invalid column name || [[SQL/MED]]
|-
| {{mono|HV008}} || X || HV || FDW-specific condition || 008 || invalid column number || [[SQL/MED]]
|-
| {{mono|HV009}} || X || HV || FDW-specific condition || 009 || invalid use of null pointer || [[SQL/MED]]
|-
| {{mono|HV00A}} || X || HV || FDW-specific condition || 00A || invalid string format || [[SQL/MED]]
|-
| {{mono|HV00B}} || X || HV || FDW-specific condition || 00B || invalid handle || [[SQL/MED]]
|-
| {{mono|HV00C}} || X || HV || FDW-specific condition || 00C || invalid option index || [[SQL/MED]]
|-
| {{mono|HV00D}} || X || HV || FDW-specific condition || 00D || invalid option name || [[SQL/MED]]
|-
| {{mono|HV00J}} || X || HV || FDW-specific condition || 00J || option name not found || [[SQL/MED]]
|-
| {{mono|HV00K}} || X || HV || FDW-specific condition || 00K || reply handle || [[SQL/MED]]
|-
| {{mono|HV00L}} || X || HV || FDW-specific condition || 00L || unable to create execution || [[SQL/MED]]
|-
| {{mono|HV00M}} || X || HV || FDW-specific condition || 00M || unable to create reply || [[SQL/MED]]
|-
| {{mono|HV00N}} || X || HV || FDW-specific condition || 00N || unable to establish connection || [[SQL/MED]]
|-
| {{mono|HV00P}} || X || HV || FDW-specific condition || 00P || no schemas || [[SQL/MED]]
|-
| {{mono|HV00Q}} || X || HV || FDW-specific condition || 00Q || schema not found || [[SQL/MED]]
|-
| {{mono|HV00R}} || X || HV || FDW-specific condition || 00R || table not found || [[SQL/MED]]
|-
| {{mono|HV010}} || X || HV || FDW-specific condition || 010 || function sequence error || [[SQL/MED]]
|-
| {{mono|HV014}} || X || HV || FDW-specific condition || 014 || limit on number of handles exceeded || [[SQL/MED]]
|-
| {{mono|HV021}} || X || HV || FDW-specific condition || 021 || inconsistent descriptor information || [[SQL/MED]]
|-
| {{mono|HV024}} || X || HV || FDW-specific condition || 024 || invalid attribute value || [[SQL/MED]]
|-
| {{mono|HV090}} || X || HV || FDW-specific condition || 090 || invalid string length or buffer length || [[SQL/MED]]
|-
| {{mono|HV091}} || X || HV || FDW-specific condition || 091 || invalid descriptor field identifier || [[SQL/MED]]
|-
| {{mono|style}}="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|HY000}} || X || HY || CLI-specific condition || 000 || {{CNone|(no subclass)}} || [[SQL/CLI]]
|-
| HY??? || X || HY || CLI-specific condition || {{n/a}} || dynamic parameter value needed || [[SQL/CLI]]
|-
| HY??? || X || HY || CLI-specific condition || {{n/a}} || invalid handle || [[SQL/CLI]]
|-
| {{mono|HY001}} || X || HY || CLI-specific condition || 001 || memory allocation error || [[SQL/CLI]]
|-
| {{mono|HY003}} || X || HY || CLI-specific condition || 003 || invalid data type in application descriptor || [[SQL/CLI]]
|-
| {{mono|HY004}} || X || HY || CLI-specific condition || 004 || invalid data type || [[SQL/CLI]]
|-
| {{mono|HY007}} || X || HY || CLI-specific condition || 007 || associated statement is not prepared || [[SQL/CLI]]
|-
| {{mono|HY008}} || X || HY || CLI-specific condition || 008 || operation canceled || [[SQL/CLI]]
|-
| {{mono|HY009}} || X || HY || CLI-specific condition || 009 || invalid use of null pointer || [[SQL/CLI]]
|-
| {{mono|HY010}} || X || HY || CLI-specific condition || 010 || function sequence error || [[SQL/CLI]]
|-
| {{mono|HY011}} || X || HY || CLI-specific condition || 011 || attribute cannot be set now || [[SQL/CLI]]
|-
| {{mono|HY012}} || X || HY || CLI-specific condition || 012 || invalid transaction operation code || [[SQL/CLI]]
|-
| {{mono|HY013}} || X || HY || CLI-specific condition || 013 || memory management error || [[SQL/CLI]]
|-
| {{mono|HY014}} || X || HY || CLI-specific condition || 014 || limit on number of handles exceeded || [[SQL/CLI]]
|-
| {{mono|HY017}} || X || HY || CLI-specific condition || 017 || invalid use of automatically allocated descriptor handle || [[SQL/CLI]]
|-
| {{mono|HY018}} || X || HY || CLI-specific condition || 018 || server declined the cancellation request || [[SQL/CLI]]
|-
| {{mono|HY019}} || X || HY || CLI-specific condition || 019 || non-string data cannot be sent in pieces || [[SQL/CLI]]
|-
| {{mono|HY020}} || X || HY || CLI-specific condition || 020 || attempt to concatenate a null value || [[SQL/CLI]]
|-
| {{mono|HY021}} || X || HY || CLI-specific condition || 021 || inconsistent descriptor information || [[SQL/CLI]]
|-
| {{mono|HY024}} || X || HY || CLI-specific condition || 024 || invalid attribute value || [[SQL/CLI]]
|-
| {{mono|HY055}} || X || HY || CLI-specific condition || 055 || non-string data cannot be used with string routine || [[SQL/CLI]]
|-
| {{mono|HY090}} || X || HY || CLI-specific condition || 090 || invalid string length or buffer length || [[SQL/CLI]]
|-
| {{mono|HY091}} || X || HY || CLI-specific condition || 091 || invalid descriptor field identifier || [[SQL/CLI]]
|-
| {{mono|HY092}} || X || HY || CLI-specific condition || 092 || invalid attribute identifier || [[SQL/CLI]]
|-
| {{mono|HY093}} || X || HY || CLI-specific condition || 093 || invalid datalink value || [[SQL/MED]]
|-
| {{mono|HY095}} || X || HY || CLI-specific condition || 095 || invalid FunctionId specified || [[SQL/CLI]]
|-
| {{mono|HY096}} || X || HY || CLI-specific condition || 096 || invalid information type || [[SQL/CLI]]
|-
| {{mono|HY097}} || X || HY || CLI-specific condition || 097 || column type out of range || [[SQL/CLI]]
|-
| {{mono|HY098}} || X || HY || CLI-specific condition || 098 || scope out of range || [[SQL/CLI]]
|-
| {{mono|HY099}} || X || HY || CLI-specific condition || 099 || nullable type out of range || [[SQL/CLI]]
|-
| {{mono|HY103}} || X || HY || CLI-specific condition || 103 || invalid retrieval code || [[SQL/CLI]]
|-
| {{mono|HY104}} || X || HY || CLI-specific condition || 104 || invalid LengthPrecision value || [[SQL/CLI]]
|-
| {{mono|HY105}} || X || HY || CLI-specific condition || 105 || invalid parameter mode || [[SQL/CLI]]
|-
| {{mono|HY106}} || X || HY || CLI-specific condition || 106 || invalid fetch orientation || [[SQL/CLI]]
|-
| {{mono|HY107}} || X || HY || CLI-specific condition || 107 || row value out of range || [[SQL/CLI]]
|-
| {{mono|HY108}} || X || HY || CLI-specific condition || 108 || invalid cursor position || [[SQL/CLI]]
|-
| {{mono|HYC00}} || X || HY || CLI-specific condition || C00 || optional feature not implemented || [[SQL/CLI]]
|-
| style="height:0.5em; background: #eaecf0;" colspan="7" |
|-
| {{mono|HZ???}} || {{dunno}} || HZ || Reserved for ISO9579 (RDA) || {{dunno}} || ||
|-
|}
==References==
{{reflist|30em|refs=
<ref name="Whitemarsh2">
{{ citation | url = https://www.wiscorp.com/sql20nn.zip | format = Zip | title = SQL:2011 draft | publisher = Whitemarsh Information Systems Corporation | archive-url = https://web.archive.org/web/20230525220603/https://www.wiscorp.com/sql20nn.zip | archive-date = 25 May 2023
}}
</ref>
}}
[[Category:SQL]]
[[Category:Relational database management systems]]
| |||