You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2006/09/01 20:09:13 UTC
svn commit: r439404 [2/2] -
/db/derby/docs/branches/10.2/src/ref/rrefexcept71493.dita
Modified: db/derby/docs/branches/10.2/src/ref/rrefexcept71493.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/ref/rrefexcept71493.dita?rev=439404&r1=439403&r2=439404&view=diff
==============================================================================
--- db/derby/docs/branches/10.2/src/ref/rrefexcept71493.dita (original)
+++ db/derby/docs/branches/10.2/src/ref/rrefexcept71493.dita Fri Sep 1 11:09:12 2006
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="utf-8"?>
-
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
+"../dtd/reference.dtd">
+<reference id="rrefexcept71493" xml:lang="en-us">
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
@@ -18,20 +18,25 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<reference id="rrefexcept71493" xml:lang="en-us">
-<title>SQLState and error message reference</title>
-<prolog><metadata>
-<keywords><indexterm>error messages</indexterm><indexterm>SQLState reference</indexterm>
-</keywords>
-</metadata></prolog>
+<!--
+NOTE: this file is generated by running org.apache.derbyBuild.ErrorMessageGenerator
+This utility reads all the error messages from the database and
+generates this file. Please do not feel obligated to update it manually
+-->
+<title>SQL error messages and exceptions</title>
<refbody>
-<section><p>The following tables list <i>SQLStates</i> for exceptions. Exceptions
+<section><p>The following tables list <i>SQLStates</i> for exceptions. Exceptions
that begin with an <i>X</i> are specific to <ph conref="refconrefs.dita#prod/productshortname"></ph>.
-Note that some SQLStates specific to the network client might change in future
-releases.</p></section>
-<section><table><title>Class Code 01: Warning</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+In the messages below each {n} tag, where n is a number, represents
+value that the Derby engine fills in at runtime. Examples of value
+include database names, database object names, property names, use
+names, and parameters passed to a function or procedure
+
+</p></section>
+<section>
+<table><title>Class 01: Warning</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
<row valign="bottom">
<entry colname="col1">SQLSTATE</entry>
@@ -40,3989 +45,4043 @@
</thead>
<tbody>
<row>
-<entry colname="col1">01001</entry>
-<entry colname="col2">An attempt to update or delete an already deleted row
-was made: No row was updated or deleted.</entry>
+<entry colname ="col1">01001</entry>
+<entry colname ="col2">An attempt to update or delete an already deleted row was made: No row was updated or deleted.</entry>
</row>
<row>
-<entry colname="col1">01003 </entry>
-<entry colname="col2">Null values were eliminated from the argument of a column
-function. </entry>
+<entry colname ="col1">01003</entry>
+<entry colname ="col2">Null values were eliminated from the argument of a column function.</entry>
</row>
<row>
-<entry colname="col1">0100E </entry>
-<entry colname="col2">XX Attempt to return too many result sets. </entry>
+<entry colname ="col1">01006</entry>
+<entry colname ="col2">Privilege not revoked from {0}.</entry>
</row>
<row>
-<entry colname="col1">01500</entry>
-<entry colname="col2">The constraint <<i>constraintName</i>> on table <<i>tableName</i>>
-has been dropped. </entry>
+<entry colname ="col1">0100E</entry>
+<entry colname ="col2">XX Attempt to return too many result sets. </entry>
</row>
<row>
-<entry colname="col1">01501</entry>
-<entry colname="col2">The view <<i>viewName</i>> has been dropped. </entry>
+<entry colname ="col1">01500</entry>
+<entry colname ="col2">The constraint {0} on table {1} has been dropped.</entry>
</row>
<row>
-<entry colname="col1">01502</entry>
-<entry colname="col2">The trigger <<i>triggerName</i>> on table <<i>tableName</i>>
-has been dropped. </entry>
+<entry colname ="col1">01501</entry>
+<entry colname ="col2">The view {0} has been dropped.</entry>
</row>
<row>
-<entry colname="col1">01503</entry>
-<entry colname="col2">The column <<i>columnName</i>> on table <<i>tableName</i>>
-has been modified by adding a not null constraint. </entry>
+<entry colname ="col1">01502</entry>
+<entry colname ="col2">The trigger {0} on table {1} has been dropped.</entry>
</row>
<row>
-<entry colname="col1">01504 </entry>
-<entry colname="col2">The new index is a duplicate of an existing index: <<i>index</i>>.
- </entry>
+<entry colname ="col1">01503</entry>
+<entry colname ="col2">The column {0} on table {1} has been modified by adding a not null constraint.</entry>
</row>
<row>
-<entry colname="col1">01505</entry>
-<entry colname="col2">The value <<i>valueName</i>> may be truncated.</entry>
+<entry colname ="col1">01504</entry>
+<entry colname ="col2">The new index is a duplicate of an existing index: {0}.</entry>
</row>
<row>
-<entry colname="col1">01522</entry>
-<entry colname="col2">The newly defined synonym '<<i>synonymName</i>>'
-resolved to the object '<<i>objectName</i>>' which is currently undefined.</entry>
+<entry colname ="col1">01505</entry>
+<entry colname ="col2">The value {0} may be truncated.</entry>
</row>
<row>
-<entry colname="col1">01J01</entry>
-<entry colname="col2">Database '<<i>databaseName</i>>' not created, connection
-made to existing database instead. </entry>
+<entry colname ="col1">01522</entry>
+<entry colname ="col2">The newly defined synonym '{0}' resolved to the object '{1}' which is currently undefined.</entry>
</row>
<row>
-<entry colname="col1">01J02</entry>
-<entry colname="col2">Scroll sensitive cursors are not currently implemented. </entry>
+<entry colname ="col1">01J01</entry>
+<entry colname ="col2">Database '{0}' not created, connection made to existing database instead.</entry>
</row>
<row>
-<entry colname="col1">01J04</entry>
-<entry colname="col2">The class '<<i>className</i>>' for column '<<i>columnName</i>>'
-does not implement java.io.Serializable or java.sql.SQLData. Instances must
-implement one of these interfaces to allow them to be stored.</entry>
+<entry colname ="col1">01J02</entry>
+<entry colname ="col2">Scroll sensitive cursors are not currently implemented.</entry>
</row>
<row>
-<entry colname="col1">01J05</entry>
-<entry colname="col2">Database upgrade succeeded. The upgraded database is
-now ready for use. Revalidating stored prepared statements failed. See next
-exception for details about failure. </entry>
+<entry colname ="col1">01J03</entry>
+<entry colname ="col2">Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.</entry>
</row>
<row>
-<entry colname="col1">01J06</entry>
-<entry colname="col2">ResultSet not updatable. Query does not qualify to generate
-an updatable ResultSet. </entry>
+<entry colname ="col1">01J04</entry>
+<entry colname ="col2">The class '{0}' for column '{1}' does not implement java.io.Serializable or java.sql.SQLData. Instances must implement one of these interfaces to allow them to be stored.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 04: Database authentication</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
-</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">04501</entry>
-<entry colname="col2">Database connection refused. </entry>
+<entry colname ="col1">01J05</entry>
+<entry colname ="col2">Database upgrade succeeded. The upgraded database is now ready for use. Revalidating stored prepared statements failed. See next exception for details of failure.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title> Class Code 07: Dynamic SQL Error</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">01J06</entry>
+<entry colname ="col2">ResultSet not updatable. Query does not qualify to generate an updatable ResultSet.</entry>
</row>
-</thead>
-<tbody>
<row>
-<entry colname="col1">07000</entry>
-<entry colname="col2">At least one parameter to the current statement is uninitialized.
- </entry>
+<entry colname ="col1">01J07</entry>
+<entry colname ="col2">ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.</entry>
</row>
<row>
-<entry colname="col1">07004</entry>
-<entry colname="col2">Parameter <<i>parameterName</i>> is a <<i>procedureName</i>>
-procedure parameter and must be registered with CallableStatement.registerOutParameter
-before execution. </entry>
+<entry colname ="col1">01J08</entry>
+<entry colname ="col2">Unable to open resultSet type {0}. ResultSet type {1} opened.</entry>
</row>
<row>
-<entry colname="col1"> 07009</entry>
-<entry colname="col2">No input parameters. </entry>
+<entry colname ="col1">01J09</entry>
+<entry colname ="col2">Unable to open ResultSet with concurrency {0}. ResultSet concurrency {1} is used.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 08: Connection Exception</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">01J10</entry>
+<entry colname ="col2">Scroll sensitive result sets are not supported by server; remapping to forward-only cursor</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">08000 </entry>
-<entry colname="col2">Connection closed by unknown interrupt. </entry>
+<row>
+<entry colname ="col1">01J11</entry>
+<entry colname ="col2">Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor</entry>
</row>
<row>
-<entry colname="col1">08003</entry>
-<entry colname="col2">No current connection. </entry>
+<entry colname ="col1">01J12</entry>
+<entry colname ="col2">Unable to obtain message text from server. See the next exception. The stored procedure SYSIBM.SQLCAMESSAGE is not installed on the server. Please contact your database administrator.</entry>
</row>
<row>
-<entry colname="col1">08004</entry>
-<entry colname="col2">Connection refused : <<i>connectionName</i>>
- </entry>
+<entry colname ="col1">01J13</entry>
+<entry colname ="col2">Number of rows returned ({0}) is too large to fit in an integer; the value returned will be truncated.</entry>
</row>
<row>
-<entry colname="col1">08006</entry>
-<entry colname="col2">Database '<<i>databaseName</i>>'</entry>
+<entry colname ="col1">01J14</entry>
+<entry colname ="col2">SQL authorization is being used without first enabling authentication.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title> Class Code 0A: Feature Not Supported</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 04: Database authentication</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
-<row>
-<entry colname="col1">SQLSTATE </entry>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
<row>
-<entry colname="col1">0A000</entry>
-<entry colname="col2">Feature not implemented: <<i>featureName</i>>.</entry>
+<entry colname ="col1">04501</entry>
+<entry colname ="col2">Database connection refused.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title> Class Code 10: XQuery Error</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 07: Dynamic SQL Error</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
-<row>
-<entry colname="col1">SQLSTATE </entry>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
<row>
-<entry colname="col1">10000</entry>
-<entry colname="col2">Encountered error while evaluating XML query expression
-for <<i>operatorName</i>> operator; see next exception for details.</entry>
+<entry colname ="col1">07000</entry>
+<entry colname ="col2">At least one parameter to the current statement is uninitialized.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title> Class Code 21: Cardinality Violation</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">07004</entry>
+<entry colname ="col2">Parameter {0} is an {1} procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">21000</entry>
-<entry colname="col2">Scalar subquery is only allowed to return a single row.</entry>
+<row>
+<entry colname ="col1">07009</entry>
+<entry colname ="col2">No input parameters.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title> Class Code 22: Data Exception</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 08: Connection Exception</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
-<row>
-<entry colname="col1">SQLSTATE </entry>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
<row>
-<entry colname="col1">2200L</entry>
-<entry colname="col2">XMLPARSE operand is not an XML document; see next exception
-for details.</entry>
+<entry colname ="col1">08000</entry>
+<entry colname ="col2">Cannot close a connection with an active transaction. The transaction remains open and the connection was not closed.</entry>
</row>
<row>
-<entry colname="col1">2200L
- </entry>
-<entry colname="col2">Values assigned to XML columns must be well-formed DOCUMENT
-nodes.
-
-
-
-
-</entry>
+<entry colname ="col1">08000</entry>
+<entry colname ="col2">Connection closed by unknown interrupt.</entry>
</row>
<row>
-<entry colname="col1">2200M</entry>
-<entry colname="col2">Failed to parse XMLPARSE operand; see next exception
-for details.</entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">Required Derby DataSource property {0} not set.</entry>
</row>
<row>
-<entry colname="col1">2200V
-</entry>
-<entry colname="col2">Invalid context item for <operatorName> operator;
-context items must be well-formed DOCUMENT nodes.
-
-</entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">{0} : Error connecting to server {1} on port {2} with message {3}.</entry>
</row>
<row>
-<entry colname="col1">22001</entry>
-<entry colname="col2">A truncation error was encountered trying to shrink <<i>value</i>>
-'<<i>value</i>>' to length <<i>value</i>></entry>
-</row>
-<row valign="top">
-<entry colname="col1">22003 </entry>
-<entry colname="col2">The resulting value is outside the range for the data
-type <<i>datatypeName</i>>. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">SocketException: '{0}'</entry>
</row>
<row>
-<entry colname="col1">22005</entry>
-<entry colname="col2">An attempt was made to get a data value of type '<<i>typeName</i>>'
-from a data value of type '<<i>typeName</i>>'. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">Unable to open stream on socket: '{0}'.</entry>
</row>
<row>
-<entry colname="col1">22007</entry>
-<entry colname="col2">The string representation of a datetime value is out
-of range. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">User id length ({0}) is outside the range of 1 to {1}.</entry>
</row>
<row>
-<entry colname="col1">22007</entry>
-<entry colname="col2">The syntax of the string representation of a datetime
-value is incorrect. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">Password length ({0}) is outside the range of 1 to {1}.</entry>
</row>
<row>
-<entry colname="col1">22008</entry>
-<entry colname="col2">'<<i>argument</i>>' is an invalid argument to the <<i>functionName</i>>
-function.</entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">User id can not be null.</entry>
</row>
<row>
-<entry colname="col1">22011</entry>
-<entry colname="col2">The second or third argument of the SUBSTR function
-is out of range. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">Password can not be null.</entry>
</row>
<row>
-<entry colname="col1">22012</entry>
-<entry colname="col2">Attempt to divide by zero. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">A connection could not be established because the database name '{0}' is larger than the maximum length allowed by the network protocol.</entry>
</row>
<row>
-<entry colname="col1">22013</entry>
-<entry colname="col2">Attempt to take the square root of a negative number,
-'<<i>number</i>>'. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">A connection could not be established because the security token is larger than the maximum allowed by the network protocol.</entry>
</row>
<row>
-<entry colname="col1">22014</entry>
-<entry colname="col2">The start position for LOCATE is invalid; it must be
-a positive integer. The index to start the search from is '<<i>index</i>>'.
- The string to search for is '<<i>index</i>>'. The string to search from
-is '<<i>index</i>>'. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">A connection could not be established because the user id has a length of zero or is larger than the maximum allowed by the network protocol.</entry>
</row>
<row>
-<entry colname="col1">22015 </entry>
-<entry colname="col2">The '<<i>functionName</i>>' function is not allowed
-on the following set of types. First operand is of type '<<i>typeName</i>>'.
-Second operand is of type '<<i>typeName</i>>'. Third operand (start position)
-is of type '<<i>typeName</i>>'. </entry>
+<entry colname ="col1">08001</entry>
+<entry colname ="col2">A connection could not be established because the password has a length of zero or is larger than the maximum allowed by the network protocol.</entry>
</row>
<row>
-<entry colname="col1">22018</entry>
-<entry colname="col2">Invalid character string format for type <<i>typeName</i>>. </entry>
+<entry colname ="col1">08003</entry>
+<entry colname ="col2">No current connection.</entry>
</row>
<row>
-<entry colname="col1">22019</entry>
-<entry colname="col2">Invalid escape sequence, '<<i>sequenceName</i>>'.
-The escape string must be exactly one character. It cannot be a null or more
-than one character. </entry>
+<entry colname ="col1">08003</entry>
+<entry colname ="col2">getConnection() is not valid on a closed PooledConnection.</entry>
</row>
<row>
-<entry colname="col1">22025</entry>
-<entry colname="col2">Escape character must be followed by escape character,
-_, or %. It cannot be followed by any other character or be at the end of
-the pattern. </entry>
+<entry colname ="col1">08003</entry>
+<entry colname ="col2">Lob method called after connection was closed</entry>
</row>
<row>
-<entry colname="col1">22027</entry>
-<entry colname="col2">The built-in TRIM() function only supports a single
-trim character. The LTRIM() and RTRIM() built-in functions support multiple
-trim characters.</entry>
+<entry colname ="col1">08003</entry>
+<entry colname ="col2">The underlying physical connection is stale or closed.</entry>
</row>
<row>
-<entry colname="col1">22501</entry>
-<entry colname="col2">An ESCAPE clause of NULL returns undefined results and
-is not allowed. </entry>
+<entry colname ="col1">08004</entry>
+<entry colname ="col2">Connection refused : {0}</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 23: Constraint Violation </title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
-</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">23502 </entry>
-<entry colname="col2">Column '<<i>columnName</i>>' cannot accept a NULL
-value. </entry>
+<entry colname ="col1">08004</entry>
+<entry colname ="col2">Connection authentication failure occurred. Reason: {0}.</entry>
</row>
<row>
-<entry colname="col1">23503</entry>
-<entry colname="col2"><<i>value</i>> on table '<<i>tableName</i>>' caused
-a violation of foreign key constraint '<<i>constraintName</i>>' for key <<i>keyName</i>>.
-The statement has been rolled back.</entry>
+<entry colname ="col1">08004</entry>
+<entry colname ="col2">The connection was refused because the database {0} was not found.</entry>
</row>
<row>
-<entry colname="col1">23505</entry>
-<entry colname="col2">The statement was aborted because it would have caused
-a duplicate key value in a unique or primary key constraint or unique index
-identified by '<<i>value</i>>' defined on '<<i>value</i>>'. </entry>
+<entry colname ="col1">08006</entry>
+<entry colname ="col2">Database '{0}' shutdown.</entry>
</row>
<row>
-<entry colname="col1">23513</entry>
-<entry colname="col2">The check constraint '<<i>constraintName</i>>' was
-violated while performing an INSERT or UPDATE on table '<<i>tableName</i>>'.</entry>
+<entry colname ="col1">08006</entry>
+<entry colname ="col2">An error occurred during connect reset and the connection has been terminated. See chained exceptions for details.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title>Class Code 24: Invalid Cursor State</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 0A: Feature not supported</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
-<row>
-<entry colname="col1">SQLSTATE </entry>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
-<row valign="top">
-<entry colname="col1">24000</entry>
-<entry colname="col2">Invalid cursor state - no current row. </entry>
+<row>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">The DRDA command {0} is not currently implemented. The connection has been terminated.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 25: Invalid Transaction State</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">JDBC method is not yet implemented.</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">25000</entry>
-<entry colname="col2">Invalid transaction state. </entry>
+<row>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">JDBC method {0} is not supported by the server. Please upgrade the server.</entry>
+</row>
+<row>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">resultSetHoldability property {0} not supported</entry>
</row>
<row>
-<entry colname="col1">25501</entry>
-<entry colname="col2">Unable to set the connection read-only property in an
-active transaction. </entry>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">cancel() not supported by the server.</entry>
</row>
<row>
-<entry colname="col1">25502</entry>
-<entry colname="col2">An SQL data change is not permitted for a read-only
-connection, user or database. </entry>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">Security mechanism '{0}' is not supported.</entry>
</row>
<row>
-<entry colname="col1">25503</entry>
-<entry colname="col2">DDL is not permitted for a read-only connection, user
-or database. </entry>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">The data type '{0}' is not supported.</entry>
</row>
<row>
-<entry colname="col1"> 25505</entry>
-<entry colname="col2">A read-only user or a user in a read-only database is
-not permitted to disable read-only mode on a connection. </entry>
+<entry colname ="col1">0A000</entry>
+<entry colname ="col2">Feature not implemented: {0}.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title>Class Code 28: Invalid Authorization Specification</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 21: Cardinality Violation</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
+</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">SQLSTATE </entry>
+<entry colname ="col1">21000</entry>
+<entry colname ="col2">Scalar subquery is only allowed to return a single row.</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 22: Data Exception</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
-<row valign="top">
-<entry colname="col1">28501 </entry>
-<entry colname="col2">Invalid database authorization property '<<i>value</i>>=<<i>value</i>>'.
- </entry>
+<row>
+<entry colname ="col1">22001</entry>
+<entry colname ="col2">A truncation error was encountered trying to shrink {0} '{1}' to length {2}.</entry>
</row>
<row>
-<entry colname="col1">28502 </entry>
-<entry colname="col2">The user name '<<i>userName</i>>' is not valid.</entry>
+<entry colname ="col1">22003</entry>
+<entry colname ="col2">The resulting value is outside the range for the data type {0}.</entry>
</row>
<row>
-<entry colname="col1">28503</entry>
-<entry colname="col2">User(s) '<<i>userName</i>>' must not be in both read-only
-and full-access authorization lists. </entry>
+<entry colname ="col1">22003</entry>
+<entry colname ="col2">Year ({0}) exceeds the maximum '{1}'.</entry>
</row>
<row>
-<entry colname="col1">28504</entry>
-<entry colname="col2">Repeated user(s) '<<i>userName</i>>' in access list
-'<<i>listName</i>>'. </entry>
+<entry colname ="col1">22003</entry>
+<entry colname ="col2">Decimal may only be up to 31 digits.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 38: External Function Exception</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">22003</entry>
+<entry colname ="col2">Overflow occurred during numeric data type conversion of '{0}' to {1}.</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">38000</entry>
-<entry colname="col2">The exception '<<i>exception</i>>' was thrown while
-evaluating an expression. </entry>
+<row>
+<entry colname ="col1">22004</entry>
+<entry colname ="col2">The length ({0}) exceeds the maximum length for the data type ({1}).</entry>
</row>
<row>
-<entry colname="col1">38001 </entry>
-<entry colname="col2">The external routine is not allowed to execute SQL statements.
- </entry>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">An attempt was made to get a data value of type '{0}' from a data value of type '{1}'.</entry>
</row>
<row>
-<entry colname="col1">38002</entry>
-<entry colname="col2">The routine attempted to modify data, but the routine
-was not defined as MODIFIES SQL DATA.</entry>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">Unable to convert a value of type '{0}' to type '{1}' : the encoding is not supported.</entry>
</row>
<row>
-<entry colname="col1">38004</entry>
-<entry colname="col2">The routine attempted to read data, but the routine
-was not defined as READS SQL DATA.</entry>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">The required character converter is not available.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 39: External Function Exception</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">Unicode string cannot convert to Ebcdic string</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">39004</entry>
-<entry colname="col2">A NULL value cannot be passed to a method which takes
-a parameter of primitive type '<<i>type</i>>'.</entry>
+<row>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">Unrecognized JDBC type. Type: {0}, columnCount: {1}, columnIndex: {2}.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 3B: Invalid SAVEPOINT</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">Invalid JDBC type for parameter {0}.</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">3B001</entry>
-<entry colname="col2">SAVEPOINT, <<i>savepoint</i>> does not exist or
-is not active in the current transaction. </entry>
+<row>
+<entry colname ="col1">22005</entry>
+<entry colname ="col2">Unrecognized Java SQL type {0}.</entry>
</row>
<row>
-<entry colname="col1">3B002</entry>
-<entry colname="col2">The maximum number of savepoints has been reached. </entry>
+<entry colname ="col1">22007</entry>
+<entry colname ="col2">The string representation of a datetime value is out of range.</entry>
</row>
<row>
-<entry colname="col1"> 3B501</entry>
-<entry colname="col2">A SAVEPOINT with the passed name already exists in the
-current transaction. </entry>
+<entry colname ="col1">22007</entry>
+<entry colname ="col2">The syntax of the string representation of a datetime value is incorrect.</entry>
</row>
<row>
-<entry colname="col1">3B502</entry>
-<entry colname="col2">A RELEASE or ROLLBACK TO SAVEPOINT was specified, but
-the savepoint does not exist. </entry>
+<entry colname ="col1">22008</entry>
+<entry colname ="col2">'{0}' is an invalid argument to the {1} function.</entry>
</row>
-</tbody>
-</tgroup>
-</table><table><title>Class Code 40: Transaction Rollback</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
-<thead>
<row>
-<entry colname="col1">SQLSTATE </entry>
-<entry colname="col2">Message Text</entry>
+<entry colname ="col1">2200L</entry>
+<entry colname ="col2">Values assigned to XML columns must be well-formed DOCUMENT nodes.</entry>
</row>
-</thead>
-<tbody>
-<row valign="top">
-<entry colname="col1">40001</entry>
-<entry colname="col2">A lock could not be obtained due to a deadlock, cycle
-of locks and waiters is: <<i>value</i>>. The selected victim is XID : <<i>value</i>>. </entry>
+<row>
+<entry colname ="col1">2200M</entry>
+<entry colname ="col2">Failed to parse XMLPARSE operand; see next exception for details.</entry>
</row>
<row>
-<entry colname="col1">40XC0</entry>
-<entry colname="col2">Dead statement. This may be caused by catching a transaction
-severity error inside this statement. </entry>
+<entry colname ="col1">2200V</entry>
+<entry colname ="col2">Invalid context item for {0} operator; context items must be well-formed DOCUMENT nodes.</entry>
</row>
<row>
-<entry colname="col1">40XD0</entry>
-<entry colname="col2">Container has been closed. </entry>
+<entry colname ="col1">22011</entry>
+<entry colname ="col2">The second or third argument of the SUBSTR function is out of range.</entry>
</row>
<row>
-<entry colname="col1">40XD1</entry>
-<entry colname="col2">Container was opened in read-only mode. </entry>
+<entry colname ="col1">22012</entry>
+<entry colname ="col2">Attempt to divide by zero.</entry>
</row>
<row>
-<entry colname="col1">40XD2</entry>
-<entry colname="col2">Container <<i>containerName</i>> cannot be opened;
-it either has been dropped or does not exist.</entry>
+<entry colname ="col1">22013</entry>
+<entry colname ="col2">Attempt to take the square root of a negative number, '{0}'.</entry>
</row>
<row>
-<entry colname="col1">40XL1</entry>
-<entry colname="col2">A lock could not be obtained within the time requested.</entry>
+<entry colname ="col1">22014</entry>
+<entry colname ="col2">The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '{2}'. The string to search for is '{0}'. The string to search from is '{1}'. </entry>
</row>
<row>
-<entry colname="col1">40XL2</entry>
-<entry colname="col2">A lock could not be obtained within the time requested.
- The lockTable dump is: <<i>tableDump</i>>.</entry>
+<entry colname ="col1">22015</entry>
+<entry colname ="col2">The '{0}' function is not allowed on the following set of types. First operand is of type '{1}'. Second operand is of type '{2}'. Third operand (start position) is of type '{3}'.</entry>
</row>
<row>
-<entry colname="col1">40XT0</entry>
-<entry colname="col2">An internal error was identified by RawStore module. </entry>
+<entry colname ="col1">22015</entry>
+<entry colname ="col2">Invalid data conversion: requested conversion would result in a loss of precision of {0}</entry>
</row>
<row>
-<entry colname="col1">40XT1</entry>
-<entry colname="col2">An exception was thrown during transaction commit.</entry>
+<entry colname ="col1">22018</entry>
+<entry colname ="col2">Invalid character string format for type {0}.</entry>
</row>
<row>
-<entry colname="col1">40XT2</entry>
-<entry colname="col2">An exception was thrown during rollback of a SAVEPOINT. </entry>
+<entry colname ="col1">22019</entry>
+<entry colname ="col2">Invalid escape sequence, '{0}'. The escape string must be exactly one character. It cannot be a null or more than one character.</entry>
</row>
<row>
-<entry colname="col1">40XT4</entry>
-<entry colname="col2">An attempt was made to close a transaction that was
-still active. The transaction has been aborted. </entry>
+<entry colname ="col1">22025</entry>
+<entry colname ="col2">Escape character must be followed by escape character, '_', or '%'. It cannot be followed by any other character or be at the end of the pattern.</entry>
</row>
<row>
-<entry colname="col1">40XT5</entry>
-<entry colname="col2">Exception thrown during an internal transaction. </entry>
+<entry colname ="col1">22027</entry>
+<entry colname ="col2">The built-in TRIM() function only supports a single trim character. The LTRIM() and RTRIM() built-in functions support multiple trim characters.</entry>
</row>
<row>
-<entry colname="col1">40XT6</entry>
-<entry colname="col2">Database is in quiescent state, cannot activate transaction.
- Please wait for a moment until it exits the inactive state. </entry>
+<entry colname ="col1">22028</entry>
+<entry colname ="col2">The string exceeds the maximum length of {0}.</entry>
</row>
<row>
-<entry colname="col1">40XT7</entry>
-<entry colname="col2">Operation is not supported in an internal transaction.
- </entry>
+<entry colname ="col1">22501</entry>
+<entry colname ="col2">An ESCAPE clause of NULL returns undefined results and is not allowed.</entry>
</row>
</tbody>
</tgroup>
-</table><table><title>Class Code 42: Syntax Error or Access Rule Violation</title>
-<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/>
+</table>
+<table><title>Class 23: Constraint Violation </title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
<thead>
-<row>
-<entry colname="col1">SQLSTATE </entry>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
</row>
</thead>
<tbody>
-<row valign="top">
-<entry colname="col1">42000</entry>
-<entry colname="col2">Syntax error or access rule violation; see additional
-errors for details. </entry>
-</row>
<row>
-<entry colname="col1">42601</entry>
-<entry colname="col2">ALTER TABLE statement cannot add an IDENTITY column
-to a table. </entry>
+<entry colname ="col1">23502</entry>
+<entry colname ="col2">Column '{0}' cannot accept a NULL value.</entry>
</row>
<row>
-<entry colname="col1">42601</entry>
-<entry colname="col2">In an ALTER TABLE statement, the column '<<i>columnName</i>>'
-has been specified as NOT NULL and either the DEFAULT clause was not specified
-or was specified as DEFAULT NULL. </entry>
+<entry colname ="col1">23503</entry>
+<entry colname ="col2">{2} on table '{1}' caused a violation of foreign key constraint '{0}' for key {3}. The statement has been rolled back.</entry>
</row>
<row>
-<entry colname="col1">42605</entry>
-<entry colname="col2">The number of arguments for function '<<i>functionName</i>>'
-is incorrect. </entry>
+<entry colname ="col1">23505</entry>
+<entry colname ="col2">The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by '{0}' defined on '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42606</entry>
-<entry colname="col2">An invalid hexadecimal constant starting with '<<i>number</i>>'
-has been detected. </entry>
+<entry colname ="col1">23513</entry>
+<entry colname ="col2">The check constraint '{1}' was violated while performing an INSERT or UPDATE on table '{0}'.</entry>
</row>
-<row>
-<entry colname="col1">42610</entry>
-<entry colname="col2">All the arguments to the COALESCE/VALUE function cannot
-be parameters. The function needs at least one argument that is not a parameter. </entry>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 24: Invalid Cursor State</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42611</entry>
-<entry colname="col2">The length, precision, or scale attribute for column,
-or type mapping '<<i>value</i>>' is not valid. </entry>
+<entry colname ="col1">24000</entry>
+<entry colname ="col2">Invalid cursor state - no current row.</entry>
</row>
<row>
-<entry colname="col1">42613</entry>
-<entry colname="col2">Multiple or conflicting keywords involving the '<<i>clause</i>>'
-clause are present. </entry>
+<entry colname ="col1">24501</entry>
+<entry colname ="col2">The identified cursor is not open.</entry>
</row>
-<row>
-<entry colname="col1">42621</entry>
-<entry colname="col2">A check constraint or generated column that is defined
-with '<<i>value</i>>' is invalid. </entry>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 25: Invalid Transaction State</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42622</entry>
-<entry colname="col2">The name '<<i>name</i>>' is too long. The maximum
-length is '<<i>maximumLength</i>>'. </entry>
+<entry colname ="col1">25000</entry>
+<entry colname ="col2">Invalid transaction state.</entry>
</row>
<row>
-<entry colname="col1">42734</entry>
-<entry colname="col2">Name '<<i>name</i>>' specified in context '<<i>context</i>>'
-is not unique. </entry>
+<entry colname ="col1">25001</entry>
+<entry colname ="col2">Cannot close a connection while a transaction is still active.</entry>
</row>
<row>
-<entry colname="col1">42802</entry>
-<entry colname="col2">The number of values assigned is not the same as the
-number of specified or implied columns. </entry>
+<entry colname ="col1">25501</entry>
+<entry colname ="col2">Unable to set the connection read-only property in an active transaction.</entry>
</row>
<row>
-<entry colname="col1">42803</entry>
-<entry colname="col2">An expression containing the column '<<i>columnName</i>>'
-appears in the SELECT list and is not part of a GROUP BY clause. </entry>
+<entry colname ="col1">25502</entry>
+<entry colname ="col2">An SQL data change is not permitted for a read-only connection, user or database.</entry>
</row>
<row>
-<entry colname="col1">42815</entry>
-<entry colname="col2">The replacement value for '<<i>value</i>>' is invalid. </entry>
+<entry colname ="col1">25503</entry>
+<entry colname ="col2">DDL is not permitted for a read-only connection, user or database.</entry>
</row>
<row>
-<entry colname="col1">42815</entry>
-<entry colname="col2">The data type, length or value of arguments '<<i>firstArguement</i>>'
-and '<<i>secondArguement</i>>' is incompatible. </entry>
+<entry colname ="col1">25505</entry>
+<entry colname ="col2">A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.</entry>
</row>
-<row>
-<entry colname="col1">42818</entry>
-<entry colname="col2">Comparisons between '<<i>value</i>>' and '<<i>value</i>>'
-are not supported. </entry>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 28: Invalid Authorization Specification</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42820</entry>
-<entry colname="col2">The floating point literal '<<i>string</i>>' contains
-more than 30 characters. </entry>
+<entry colname ="col1">28501</entry>
+<entry colname ="col2">Invalid database authorization property '{0}={1}'.</entry>
</row>
<row>
-<entry colname="col1">42821</entry>
-<entry colname="col2">Columns of type '<<i>type</i>>' cannot hold values
-of type '<<i>type</i>>'. </entry>
+<entry colname ="col1">28502</entry>
+<entry colname ="col2">The user name '{0}' is not valid. </entry>
</row>
<row>
-<entry colname="col1">42824</entry>
-<entry colname="col2">An operand of LIKE is not a string, or the first operand
-is not a column.</entry>
+<entry colname ="col1">28503</entry>
+<entry colname ="col2">User(s) '{0}' must not be in both read-only and full-access authorization lists.</entry>
</row>
<row>
-<entry colname="col1">42831</entry>
-<entry colname="col2">'<<i>columnName</i>>' cannot be a column of a primary
-key or unique key because it can contain null values.</entry>
+<entry colname ="col1">28504</entry>
+<entry colname ="col2">Repeated user(s) '{1}' in access list '{0}';</entry>
</row>
<row>
-<entry colname="col1">42834</entry>
-<entry colname="col2">SET NULL cannot be specified because FOREIGN KEY '<<i>key</i>>'
- cannot contain null values.</entry>
+<entry colname ="col1">28505</entry>
+<entry colname ="col2">Internal Error: invalid {0} id in statement permission list.</entry>
</row>
<row>
-<entry colname="col1">42837</entry>
-<entry colname="col2">ALTER TABLE '<<i>tableName</i>>' specified attributes
-for column '<<i>columnName</i>>' that are not compatible with the existing
-column. </entry>
+<entry colname ="col1">28506</entry>
+<entry colname ="col2">User '{0}' does not have {1} permission on table '{2}'.'{3}'.</entry>
</row>
<row>
-<entry colname="col1">42846</entry>
-<entry colname="col2">Cannot convert types '<<i>type</i>>' to '<<i>type</i>>'. </entry>
+<entry colname ="col1">28507</entry>
+<entry colname ="col2">User '{0}' does not have {1} permission on table '{2}'.'{3}' for grant.</entry>
</row>
<row>
-<entry colname="col1">42877</entry>
-<entry colname="col2">A qualified column name '<<i>columnName</i>>' is
-not allowed in the ORDER BY clause. </entry>
+<entry colname ="col1">28508</entry>
+<entry colname ="col2">User '{0}' does not have {1} permission on column '{2}' of table '{3}'.'{4}'.</entry>
</row>
<row>
-<entry colname="col1">42884</entry>
-<entry colname="col2">No authorized routine named '<<i>routineName</i>>'
-of type '<<i>type</i>>' having compatible arguments was found. </entry>
+<entry colname ="col1">28509</entry>
+<entry colname ="col2">User '{0}' does not have {1} permission on column '{2}' of table '{3}'.'{4}' for grant.</entry>
</row>
<row>
-<entry colname="col1">42886</entry>
-<entry colname="col2">'<<i>value</i>>' parameter '<<i>value</i>>' requires
-a parameter marker '<<i>parameter</i>>'. </entry>
+<entry colname ="col1">2850A</entry>
+<entry colname ="col2">User '{0}' does not have execute permission on {1} '{2}'.'{3}'.</entry>
</row>
<row>
-<entry colname="col1">42894</entry>
-<entry colname="col2">DEFAULT value or IDENTITY attribute value is not valid
-for column '<<i>columnName</i>>'. </entry>
+<entry colname ="col1">2850B</entry>
+<entry colname ="col2">User '{0}' does not have execute permission on {1} '{2}'.'{3}' for grant.</entry>
</row>
<row>
-<entry colname="col1">428C1</entry>
-<entry colname="col2">Only one identity column is allowed in a table.</entry>
+<entry colname ="col1">2850C</entry>
+<entry colname ="col2">User '{0}' is not the owner of {1} '{2}'.'{3}'.</entry>
</row>
<row>
-<entry colname="col1">428EK</entry>
-<entry colname="col2">The qualifier for a declared global temporary table
-name must be SESSION. </entry>
+<entry colname ="col1">2850D</entry>
+<entry colname ="col2">User '{0}' can not perform the operation in schema '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42903</entry>
-<entry colname="col2">Invalid use of an aggregate function. </entry>
+<entry colname ="col1">2850E</entry>
+<entry colname ="col2">User '{0}' can not create schema '{1}'. Only database owner could issue this statement.</entry>
</row>
<row>
-<entry colname="col1">42908</entry>
-<entry colname="col2">The CREATE VIEW statement does not include a column
-list. </entry>
+<entry colname ="col1">2850F</entry>
+<entry colname ="col2">Specified grant or revoke operation is not allowed on object '{0}'.</entry>
</row>
-<row>
-<entry colname="col1">42915 </entry>
-<entry colname="col2">Foreign Key '<<i>key</i>>' is invalid because '<<i>value</i>>'.</entry>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 2D: Invalid Transaction Termination</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42916</entry>
-<entry colname="col2">Synonym '<<i>synonym2</i>>' cannot be created for
-'<<i>synonym1</i>>' as it would result in a circular synonym chain.</entry>
+<entry colname ="col1">2D521</entry>
+<entry colname ="col2">setAutoCommit(true) invalid during global transaction.</entry>
</row>
<row>
-<entry colname="col1">42939</entry>
-<entry colname="col2">An object cannot be created with the schema name '<<i>schemaName</i>>'.
- </entry>
+<entry colname ="col1">2D521</entry>
+<entry colname ="col2">COMMIT or ROLLBACK invalid for application execution environment. </entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 38: External Function Exception</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42962</entry>
-<entry colname="col2">Long column type column or parameter '<<i>columnName</i>>'
-not permitted in declared global temporary tables or procedure definitions.
- </entry>
+<entry colname ="col1">38000</entry>
+<entry colname ="col2">The exception '{0}' was thrown while evaluating an expression.</entry>
</row>
<row>
-<entry colname="col1">42972</entry>
-<entry colname="col2">An ON clause associated with a JOIN operator is not
-valid. </entry>
+<entry colname ="col1">38001</entry>
+<entry colname ="col2">The external routine is not allowed to execute SQL statements.</entry>
</row>
<row>
-<entry colname="col1">42995</entry>
-<entry colname="col2">The requested function does not apply to global temporary
-tables. </entry>
+<entry colname ="col1">38002</entry>
+<entry colname ="col2">The routine attempted to modify data, but the routine was not defined as MODIFIES SQL DATA.</entry>
</row>
<row>
-<entry colname="col1">42X01 </entry>
-<entry colname="col2">Syntax error: <<i>error</i>>. </entry>
+<entry colname ="col1">38004</entry>
+<entry colname ="col2">The routine attempted to read data, but the routine was not defined as READS SQL DATA.</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 39: External Routine Invocation Exception</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42X02</entry>
-<entry colname="col2"><<i>value</i>>. </entry>
+<entry colname ="col1">39004</entry>
+<entry colname ="col2">A NULL value cannot be passed to a method which takes a parameter of primitive type '{0}'.</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 3B: Invalid SAVEPOINT</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42X03</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' is in more than
-one table in the FROM list. </entry>
+<entry colname ="col1">3B001</entry>
+<entry colname ="col2">SAVEPOINT, {0} does not exist or is not active in the current transaction.</entry>
</row>
<row>
-<entry colname="col1">42X04</entry>
-<entry colname="col2">Column '<<i>columnName</i>>' is either not in any
-table in the FROM list or appears within a join specification and is outside
-the scope of the join specification or appears in a HAVING clause and is not
-in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then
-'<<i>columnName</i>>' is not a column in the target table. </entry>
+<entry colname ="col1">3B002</entry>
+<entry colname ="col2">The maximum number of savepoints has been reached. </entry>
</row>
<row>
-<entry colname="col1">42X05</entry>
-<entry colname="col2">Table '<<i>tableName</i>>' does not exist. </entry>
+<entry colname ="col1">3B501</entry>
+<entry colname ="col2">A SAVEPOINT with the passed name already exists in the current transaction.</entry>
</row>
<row>
-<entry colname="col1">42X06</entry>
-<entry colname="col2">Too many result columns specified for table '<<i>tableName</i>>'.
- </entry>
+<entry colname ="col1">3B502</entry>
+<entry colname ="col2">A RELEASE or ROLLBACK TO SAVEPOINT was specified, but the savepoint does not exist.</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 40: Transaction Rollback</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42X07</entry>
-<entry colname="col2">Null is only allowed in a VALUES clause within an INSERT
-statement. </entry>
+<entry colname ="col1">40001</entry>
+<entry colname ="col2">A lock could not be obtained due to a deadlock, cycle of locks and waiters is
+{0}. The selected victim is XID : {1}.</entry>
</row>
<row>
-<entry colname="col1">42X08</entry>
-<entry colname="col2">The constructor for class '<<i>className</i>>' cannot
-be used as an external virtual table because the class does not implement
-'<<i>constructorName</i>>'. </entry>
+<entry colname ="col1">40XC0</entry>
+<entry colname ="col2">Dead statement. This may be caused by catching a transaction severity error inside this statement.</entry>
</row>
<row>
-<entry colname="col1">42X09</entry>
-<entry colname="col2">The table or alias name '<<i>tableName</i>>' is used
-more than once in the FROM list. </entry>
+<entry colname ="col1">40XD0</entry>
+<entry colname ="col2">Container has been closed</entry>
</row>
<row>
-<entry colname="col1">42X10</entry>
-<entry colname="col2"> '<<i>tableName</i>>' is not an exposed table name
-in the scope in which it appears. </entry>
+<entry colname ="col1">40XD1</entry>
+<entry colname ="col2">Container was opened in read-only mode. </entry>
</row>
<row>
-<entry colname="col1">42X12</entry>
-<entry colname="col2">Column name '<<i>tableName</i>>' appears more than
-once in the CREATE TABLE statement. </entry>
+<entry colname ="col1">40XD2</entry>
+<entry colname ="col2">Container {0} cannot be opened; it either has been dropped or does not exist.</entry>
</row>
<row>
-<entry colname="col1">42X13</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears more than
-once in the column list of an INSERT statement. </entry>
+<entry colname ="col1">40XL1</entry>
+<entry colname ="col2">A lock could not be obtained within the time requested</entry>
</row>
<row>
-<entry colname="col1">42X14</entry>
-<entry colname="col2">'<<i>columnName</i>>' is not a column in table or
-VTI '<<i>value</i>>'. </entry>
+<entry colname ="col1">40XL2</entry>
+<entry colname ="col2">A lock could not be obtained within the time requested. The lockTable dump is: {0}</entry>
</row>
<row>
-<entry colname="col1">42X15</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears in a statement
-without a FROM list. </entry>
+<entry colname ="col1">40XT0</entry>
+<entry colname ="col2">An internal error was identified by RawStore module.</entry>
</row>
<row>
-<entry colname="col1">42X16</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears multiple
-times in the SET clause of an UPDATE statement. </entry>
+<entry colname ="col1">40XT1</entry>
+<entry colname ="col2">An exception was thrown during transaction commit.</entry>
</row>
<row>
-<entry colname="col1">42X17</entry>
-<entry colname="col2">In the Properties list of a FROM clause, the value '<<i>value</i>>'
-is not valid as a joinOrder specification. Only the values FIXED and UNFIXED
-are valid. </entry>
+<entry colname ="col1">40XT2</entry>
+<entry colname ="col2">An exception was thrown during rollback of a SAVEPOINT.</entry>
</row>
<row>
-<entry colname="col1">42X19</entry>
-<entry colname="col2">The WHERE or HAVING clause or CHECK CONSTRAINT definition
-is a '<<i>value</i>>' expression. It must be a BOOLEAN expression. </entry>
+<entry colname ="col1">40XT4</entry>
+<entry colname ="col2">An attempt was made to close a transaction that was still active. The transaction has been aborted.</entry>
</row>
<row>
-<entry colname="col1">42X23</entry>
-<entry colname="col2">Cursor <<i>cursorName</i>> is not updatable. </entry>
+<entry colname ="col1">40XT5</entry>
+<entry colname ="col2">Exception thrown during an internal transaction.</entry>
</row>
<row>
-<entry colname="col1">42X25</entry>
-<entry colname="col2">The '<<i>functionName</i>>' function is not allowed
-on the '<<i>type</i>>' type. </entry>
+<entry colname ="col1">40XT6</entry>
+<entry colname ="col2">Database is in quiescent state, cannot activate transaction. Please wait for a moment till it exits the quiescent state.</entry>
</row>
<row>
-<entry colname="col1">42X26</entry>
-<entry colname="col2">The class '<<i>className</i>> for column '<<i>columnName</i>>'
-does not exist or is inaccessible. This can happen if the class is not public.
- </entry>
+<entry colname ="col1">40XT7</entry>
+<entry colname ="col2">Operation is not supported in an internal transaction.</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Class 42: Syntax Error or Access Rule Violation</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="1*"/><colspec colname="col2"
+colwidth="7.5*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="col1">42X28</entry>
-<entry colname="col2">Delete table '<<i>tableName</i>>' is not target of
-cursor '<<i>cursorName</i>>'. </entry>
+<entry colname ="col1">42000</entry>
+<entry colname ="col2">Syntax error or access rule violation; see additional errors for details.</entry>
</row>
<row>
-<entry colname="col1">42X29</entry>
-<entry colname="col2">Update table '<<i>tableName</i>>' is not the target
-of cursor '<<i>cursorName</i>>'. </entry>
+<entry colname ="col1">42601</entry>
+<entry colname ="col2">ALTER TABLE statement cannot add an IDENTITY column to a table.</entry>
</row>
<row>
-<entry colname="col1">42X30</entry>
-<entry colname="col2">Cursor '<<i>cursorName</i>>' not found. Verify that
-autocommit is OFF. </entry>
+<entry colname ="col1">42601</entry>
+<entry colname ="col2">In an ALTER TABLE statement, the column '{0}' has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL.</entry>
</row>
<row>
-<entry colname="col1">42X31</entry>
-<entry colname="col2">Column '<<i>columnName</i>>' is not in the FOR UPDATE
-list of cursor '<<i>cursorName</i>>'. </entry>
+<entry colname ="col1">42605</entry>
+<entry colname ="col2">The number of arguments for function '{0}' is incorrect.</entry>
</row>
<row>
-<entry colname="col1">42X32</entry>
-<entry colname="col2">The number of columns in the derived column list must
-match the number of columns in table '<<i>tableName</i>>'.</entry>
+<entry colname ="col1">42606</entry>
+<entry colname ="col2">An invalid hexadecimal constant starting with '{0}' has been detected.</entry>
</row>
<row>
-<entry colname="col1">42X33</entry>
-<entry colname="col2">The derived column list contains a duplicate column
-name '<<i>columnName</i>>'. </entry>
+<entry colname ="col1">42610</entry>
+<entry colname ="col2">All the arguments to the COALESCE/VALUE function cannot be parameters. The function needs at least one argument that is not a parameter.</entry>
</row>
<row>
-<entry colname="col1">42X34</entry>
-<entry colname="col2">There is a ? parameter in the select list. This is
-not allowed. </entry>
+<entry colname ="col1">42611</entry>
+<entry colname ="col2">The length, precision, or scale attribute for column, or type mapping '{0}' is not valid. </entry>
</row>
<row>
-<entry colname="col1">42X35 </entry>
-<entry colname="col2">It is not allowed for both operands of '<<i>value</i>>'
-to be ? parameters. </entry>
+<entry colname ="col1">42613</entry>
+<entry colname ="col2">Multiple or conflicting keywords involving the '{0}' clause are present.</entry>
</row>
<row>
-<entry colname="col1">42X36</entry>
-<entry colname="col2">The '<<i>operator</i>>' operator is not allowed to
-take a ? parameter as an operand.</entry>
+<entry colname ="col1">42621</entry>
+<entry colname ="col2">A check constraint or generated column that is defined with '{0}' is invalid.</entry>
</row>
<row>
-<entry colname="col1">42X37</entry>
-<entry colname="col2">The unary '<<i>operator</i>>' operator is not allowed
-on the '<<i>type</i>>' type. </entry>
+<entry colname ="col1">42622</entry>
+<entry colname ="col2">The name '{0}' is too long. The maximum length is '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X38</entry>
-<entry colname="col2">'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries.
- </entry>
+<entry colname ="col1">42734</entry>
+<entry colname ="col2">Name '{0}' specified in context '{1}' is not unique.</entry>
</row>
<row>
-<entry colname="col1">42X39</entry>
-<entry colname="col2">Subquery is only allowed to return a single column. </entry>
+<entry colname ="col1">42802</entry>
+<entry colname ="col2">The number of values assigned is not the same as the number of specified or implied columns.</entry>
</row>
<row>
-<entry colname="col1">42X40</entry>
-<entry colname="col2">A NOT statement has an operand that is not boolean .
-The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN. </entry>
+<entry colname ="col1">42803</entry>
+<entry colname ="col2">An expression containing the column '{0}' appears in the SELECT list and is not part of a GROUP BY clause.</entry>
</row>
<row>
-<entry colname="col1">42X41</entry>
-<entry colname="col2">In the Properties clause of a FROM list, the property
-'<<i>propertyName</i>>' is not valid (the property was being set to '<<i>value</i>>'). </entry>
+<entry colname ="col1">42815</entry>
+<entry colname ="col2">The data type, length or value of arguments '{0}' and '{1}' is incompatible.</entry>
</row>
<row>
-<entry colname="col1">42X42</entry>
-<entry colname="col2">Correlation name not allowed for column '<<i>columnName</i>>'
-because it is part of the FOR UPDATE list.</entry>
+<entry colname ="col1">42815</entry>
+<entry colname ="col2">The replacement value for '{0}' is invalid.</entry>
</row>
<row>
-<entry colname="col1">42X43</entry>
-<entry colname="col2">The ResultSetMetaData returned for the class/object
-'<<i>className</i>>' was null. In order to use this class as an external
-virtual table, the ResultSetMetaData cannot be null. </entry>
+<entry colname ="col1">42818</entry>
+<entry colname ="col2">Comparisons between '{0}' and '{1}' are not supported.</entry>
</row>
<row>
-<entry colname="col1">42X44 </entry>
-<entry colname="col2">Invalid length '<<i>length</i>>' in column specification.
- </entry>
+<entry colname ="col1">42820</entry>
+<entry colname ="col2">The floating point literal '{0}' contains more than 30 characters.</entry>
</row>
<row>
-<entry colname="col1">42X45</entry>
-<entry colname="col2"><<i>type</i>> is an invalid type for argument number <<i>value</i>>
-of <<i>value</i>>.</entry>
+<entry colname ="col1">42821</entry>
+<entry colname ="col2">Columns of type '{0}' cannot hold values of type '{1}'. </entry>
</row>
<row>
-<entry colname="col1">42X48</entry>
-<entry colname="col2">Value '<<i>value</i>>' is not a valid precision for <<i>value</i>>.</entry>
+<entry colname ="col1">42824</entry>
+<entry colname ="col2">An operand of LIKE is not a string, or the first operand is not a column.</entry>
</row>
<row>
-<entry colname="col1">42X49</entry>
-<entry colname="col2">Value '<<i>value</i>>' is not a valid integer literal.</entry>
+<entry colname ="col1">42831</entry>
+<entry colname ="col2">'{0}' cannot be a column of a primary key or unique key because it can contain null values.</entry>
</row>
<row>
-<entry colname="col1">42X50</entry>
-<entry colname="col2">No method was found that matched the method call <<i>methodName</i>>.<<i>value</i>>(<<i>value</i>>),
-tried all combinations of object and primitive types and any possible type
-conversion for any parameters the method call may have. The method might
-exist but it is not public and/or static, or the parameter types are not method
-invocation convertible.</entry>
+<entry colname ="col1">42834</entry>
+<entry colname ="col2">SET NULL cannot be specified because FOREIGN KEY '{0}' cannot contain null values. </entry>
</row>
<row>
-<entry colname="col1">42X51</entry>
-<entry colname="col2">The class '<<i>className</i>>' does not exist or
-is inaccessible. This can happen if the class is not public. </entry>
+<entry colname ="col1">42837</entry>
+<entry colname ="col2">ALTER TABLE '{0}' specified attributes for column '{1}' that are not compatible with the existing column.</entry>
</row>
<row>
-<entry colname="col1">42X52</entry>
-<entry colname="col2">Calling method ('<<i>methodName</i>>') using a receiver
-of the Java primitive type '<<i>type</i>>" is not allowed. </entry>
+<entry colname ="col1">42846</entry>
+<entry colname ="col2">Cannot convert types '{0}' to '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X53 </entry>
-<entry colname="col2">The LIKE predicate can only have 'CHAR' or 'VARCHAR'
-operands. Type '<<i>type</i>>' is not permitted. </entry>
+<entry colname ="col1">42877</entry>
+<entry colname ="col2">A qualified column name '{0}' is not allowed in the ORDER BY clause.</entry>
</row>
<row>
-<entry colname="col1">42X54</entry>
-<entry colname="col2">The Java method '<<i>methodName</i>>' has a ? as
-a receiver. This is not allowed.</entry>
+<entry colname ="col1">42884</entry>
+<entry colname ="col2">No authorized routine named '{0}' of type '{1}' having compatible arguments was found.</entry>
</row>
<row>
-<entry colname="col1">42X55</entry>
-<entry colname="col2">Table name '<<i>tableName</i>>' should be the same
-as '<<i>value</i>>'. </entry>
+<entry colname ="col1">42886</entry>
+<entry colname ="col2">'{0}' parameter '{1}' requires a parameter marker '?'.</entry>
</row>
<row>
-<entry colname="col1">42X56</entry>
-<entry colname="col2">The number of columns in the view column list does not
-match the number of columns in the underlying query expression in the view
-definition for '<<i>value</i>>'. </entry>
+<entry colname ="col1">42894</entry>
+<entry colname ="col2">DEFAULT value or IDENTITY attribute value is not valid for column '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42X57</entry>
-<entry colname="col2">The getColumnCount() for external virtual table '<<i>tableName</i>>'
-returned an invalid value '<<i>value</i>>'. Valid values are greater than
-or equal to 1. </entry>
+<entry colname ="col1">428C1</entry>
+<entry colname ="col2">Only one identity column is allowed in a table.</entry>
</row>
<row>
-<entry colname="col1">42X58</entry>
-<entry colname="col2">The number of columns on the left and right sides of
-the <<i>tableName</i>> must be the same.</entry>
+<entry colname ="col1">428EK</entry>
+<entry colname ="col2">The qualifier for a declared global temporary table name must be SESSION.</entry>
</row>
<row>
-<entry colname="col1">42X59</entry>
-<entry colname="col2">The number of columns in each VALUES constructor must
-be the same. </entry>
+<entry colname ="col1">42903</entry>
+<entry colname ="col2">Invalid use of an aggregate function.</entry>
</row>
<row>
-<entry colname="col1">42X60</entry>
-<entry colname="col2">Invalid value '<<i>value</i>>' for insertMode property
-specified for table '<<i>tableName</i>>'. </entry>
+<entry colname ="col1">42908</entry>
+<entry colname ="col2">The CREATE VIEW statement does not include a column list.</entry>
</row>
<row>
-<entry colname="col1">42X61 </entry>
-<entry colname="col2">Types '<<i>type</i>>' and '<<i>type</i>>' are
-not <<i>value</i>> compatible. </entry>
+<entry colname ="col1">42915</entry>
+<entry colname ="col2">Foreign Key '{0}' is invalid because '{1}'. </entry>
</row>
<row>
-<entry colname="col1">42X62</entry>
-<entry colname="col2">'<<i>value</i>>' is not allowed in the '<<i>schemaName</i>>'
-schema. </entry>
+<entry colname ="col1">42916</entry>
+<entry colname ="col2">Synonym '{0}' cannot be created for '{1}' as it would result in a circular synonym chain.</entry>
</row>
<row>
-<entry colname="col1">42X63</entry>
-<entry colname="col2">The USING clause did not return any results. No parameters
-can be set. </entry>
+<entry colname ="col1">42939</entry>
+<entry colname ="col2">An object cannot be created with the schema name '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42X64</entry>
-<entry colname="col2">In the Properties list, the invalid value '<<i>value</i>>'
-was specified for the useStatistics property. The only valid values are TRUE
-or FALSE . </entry>
+<entry colname ="col1">42962</entry>
+<entry colname ="col2">Long column type column or parameter '{0}' not permitted in declared global temporary tables or procedure definitions. </entry>
</row>
<row>
-<entry colname="col1">42X65</entry>
-<entry colname="col2">Index '<<i>index</i>>' does not exist. </entry>
+<entry colname ="col1">42972</entry>
+<entry colname ="col2">An ON clause associated with a JOIN operator is not valid.</entry>
</row>
<row>
-<entry colname="col1">42X66</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears more than
-once in the CREATE INDEX statement. </entry>
+<entry colname ="col1">42995</entry>
+<entry colname ="col2">The requested function does not apply to global temporary tables.</entry>
</row>
<row>
-<entry colname="col1">42X68</entry>
-<entry colname="col2">No field '<<i>fieldName</i>>' was found belonging
-to class '<<i>className</i>>'. The field might exist, but it is not public,
-or the class does not exist or is not public. </entry>
+<entry colname ="col1">42X01</entry>
+<entry colname ="col2">Syntax error: {0}.</entry>
</row>
<row>
-<entry colname="col1">42X69</entry>
-<entry colname="col2">It is not allowed to reference a field ('<<i>fieldName</i>>')
-using a referencing expression of the Java primitive type '<<i>type</i>>'. </entry>
+<entry colname ="col1">42X02</entry>
+<entry colname ="col2">{0}.</entry>
</row>
<row>
-<entry colname="col1">42X72</entry>
-<entry colname="col2">No static field '<<i>fieldName</i>>' was found belonging
-to class '<<i>className</i>>'. The field might exist, but it is not public
-and/or static, or the class does not exist or the class is not public. </entry>
+<entry colname ="col1">42X03</entry>
+<entry colname ="col2">Column name '{0}' is in more than one table in the FROM list.</entry>
</row>
<row>
-<entry colname="col1">42X73</entry>
-<entry colname="col2">Method resolution for signature <<i>value</i>>.<<i>value</i>>(<<i>value</i>>)
-was ambiguous. (No single maximally specific method.) </entry>
+<entry colname ="col1">42X04</entry>
+<entry colname ="col2">Column '{0}' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then '{0}' is not a column in the target table.</entry>
</row>
<row>
-<entry colname="col1">42X74</entry>
-<entry colname="col2">Invalid CALL statement syntax.</entry>
+<entry colname ="col1">42X05</entry>
+<entry colname ="col2">Table/View '{0}' does not exist.</entry>
</row>
<row>
-<entry colname="col1">42X75</entry>
-<entry colname="col2">No constructor was found with the signature <<i>value</i>>(<<i>value</i>>).
- It may be that the parameter types are not method invocation convertible.</entry>
+<entry colname ="col1">42X06</entry>
+<entry colname ="col2">Too many result columns specified for table '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42X76</entry>
-<entry colname="col2">At least one column, '<<i>columnName</i>>', in the
-primary key being added is nullable. All columns in a primary key must be
-non-nullable. </entry>
+<entry colname ="col1">42X07</entry>
+<entry colname ="col2">Null is only allowed in a VALUES clause within an INSERT statement.</entry>
</row>
<row>
-<entry colname="col1">42X77</entry>
-<entry colname="col2">Column position '<<i>columnPosition</i>>' is out
-of range for the query expression. </entry>
+<entry colname ="col1">42X08</entry>
+<entry colname ="col2">The constructor for class '{0}' cannot be used as an external virtual table because the class does not implement '{1}'. </entry>
</row>
<row>
-<entry colname="col1">42X78</entry>
-<entry colname="col2">Column '<<i>columnName</i>>' is not in the result
-of the query expression. </entry>
+<entry colname ="col1">42X09</entry>
+<entry colname ="col2">The table or alias name '{0}' is used more than once in the FROM list.</entry>
</row>
<row>
-<entry colname="col1">42X79</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears more than
-once in the result of the query expression. </entry>
+<entry colname ="col1">42X10</entry>
+<entry colname ="col2">'{0}' is not an exposed table name in the scope in which it appears.</entry>
</row>
<row>
-<entry colname="col1">42X80</entry>
-<entry colname="col2">VALUES clause must contain at least one element. Empty
-elements are not allowed. </entry>
+<entry colname ="col1">42X12</entry>
+<entry colname ="col2">Column name '{0}' appears more than once in the CREATE TABLE statement. </entry>
</row>
<row>
-<entry colname="col1">42X82</entry>
-<entry colname="col2">The USING clause returned more than one row. Only single-row
-ResultSets are permissible. </entry>
+<entry colname ="col1">42X13</entry>
+<entry colname ="col2">Column name '{0}' appears more than once times in the column list of an INSERT statement. </entry>
</row>
<row>
-<entry colname="col1">42X83</entry>
-<entry colname="col2">The constraints on column '<<i>columnName</i>>' require
-that it be both nullable and not nullable. </entry>
+<entry colname ="col1">42X14</entry>
+<entry colname ="col2">'{0}' is not a column in table or VTI '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X84</entry>
-<entry colname="col2">Index '<<i>index</i>>' was created to enforce constraint
-'<<i>constraintName</i>>'. It can only be dropped by dropping the constraint. </entry>
+<entry colname ="col1">42X15</entry>
+<entry colname ="col2">Column name '{0}' appears in a statement without a FROM list.</entry>
</row>
<row>
-<entry colname="col1">42X85</entry>
-<entry colname="col2">Constraint '<<i>constraintName</i>>' is required
-to be in the same schema as table '<<i>tableName</i>>'. </entry>
+<entry colname ="col1">42X16</entry>
+<entry colname ="col2">Column name '{0}' appears multiple times in the SET clause of an UPDATE statement.</entry>
</row>
<row>
-<entry colname="col1">42X86</entry>
-<entry colname="col2">ALTER TABLE failed. There is no constraint '<<i>constraintName</i>>'
-on table '<<i>tableName</i>>'. </entry>
+<entry colname ="col1">42X17</entry>
+<entry colname ="col2">In the Properties list of a FROM clause, the value '{0}' is not valid as a joinOrder specification. Only the values FIXED and UNFIXED are valid. </entry>
</row>
<row>
-<entry colname="col1">42X87</entry>
-<entry colname="col2">At least one result expression (THEN or ELSE) of the
-'<<i>expression</i>>' expression must not be a '?'. </entry>
+<entry colname ="col1">42X19</entry>
+<entry colname ="col2">The WHERE or HAVING clause or CHECK CONSTRAINT definition is a '{0}' expression. It must be a BOOLEAN expression.</entry>
</row>
<row>
-<entry colname="col1">42X88</entry>
-<entry colname="col2">A conditional has a non-boolean operand. The operand
-of a conditional must evaluate to TRUE, FALSE, or UNKNOWN. </entry>
+<entry colname ="col1">42X23</entry>
+<entry colname ="col2">Cursor {0} is not updatable.</entry>
</row>
<row>
-<entry colname="col1">42X89</entry>
-<entry colname="col2">Types '<<i>type</i>>' and '<<i>type</i>>' are
-not type compatible. Neither type is assignable to the other type. </entry>
+<entry colname ="col1">42X25</entry>
+<entry colname ="col2">The '{0}' function is not allowed on the '{1}' type.</entry>
</row>
<row>
-<entry colname="col1">42X90</entry>
-<entry colname="col2">More than one primary key constraint specified for table
-'<<i>tableName</i>>'. </entry>
+<entry colname ="col1">42X26</entry>
+<entry colname ="col2">The class '{0}' for column '{1}' does not exist or is inaccessible. This can happen if the class is not public.</entry>
</row>
<row>
-<entry colname="col1">42X91</entry>
-<entry colname="col2">Constraint name '<<i>constraintName</i>>' appears
-more than once in the CREATE TABLE statement. </entry>
+<entry colname ="col1">42X28</entry>
+<entry colname ="col2">Delete table '{0}' is not target of cursor '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X92</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears more than
-once in a constraint's column list.</entry>
+<entry colname ="col1">42X29</entry>
+<entry colname ="col2">Update table '{0}' is not the target of cursor '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X93</entry>
-<entry colname="col2">Table '<<i>tableName</i>>' contains a constraint
-definition with column '<<i>columnName</i>>' which is not in the table. </entry>
+<entry colname ="col1">42X30</entry>
+<entry colname ="col2">Cursor '{0}' not found. Verify that autocommit is OFF.</entry>
</row>
<row>
-<entry colname="col1">42X94</entry>
-<entry colname="col2"><<i>value</i>> '<<i>value</i>>' does not exist.</entry>
+<entry colname ="col1">42X31</entry>
+<entry colname ="col2">Column '{0}' is not in the FOR UPDATE list of cursor '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42X96</entry>
-<entry colname="col2">The database classpath contains an unknown jar file
-'<<i>fileName</i>>'. </entry>
+<entry colname ="col1">42X32</entry>
+<entry colname ="col2">The number of columns in the derived column list must match the number of columns in table '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42X98</entry>
-<entry colname="col2">Parameters are not allowed in a VIEW definition. </entry>
+<entry colname ="col1">42X33</entry>
+<entry colname ="col2">The derived column list contains a duplicate column name '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42Y00</entry>
-<entry colname="col2">Class '<<i>className</i>>' does not implement org.apache.derby.iapi.db.AggregateDefinition
-and thus cannot be used as an aggregate expression.</entry>
+<entry colname ="col1">42X34</entry>
+<entry colname ="col2">There is a ? parameter in the select list. This is not allowed.</entry>
</row>
<row>
-<entry colname="col1">42Y01</entry>
-<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid.
- </entry>
+<entry colname ="col1">42X35</entry>
+<entry colname ="col2">It is not allowed for both operands of '{0}' to be ? parameters.</entry>
</row>
<row>
-<entry colname="col1">42Y03</entry>
-<entry colname="col2">'<<i>statement</i>>' is not recognized as a function
-or procedure. </entry>
+<entry colname ="col1">42X36</entry>
+<entry colname ="col2">The '{0}' operator is not allowed to take a ? parameter as an operand.</entry>
</row>
<row>
-<entry colname="col1">42Y04</entry>
-<entry colname="col2">Cannot create a procedure or function with EXTERNAL
-NAME '<<i>name</i>>' because it is not a list separated by periods. The
-expected format is <<i>fulljavapath</i>>.<<i>method name</i>>.</entry>
+<entry colname ="col1">42X37</entry>
+<entry colname ="col2">The unary '{0}' operator is not allowed on the '{1}' type.</entry>
</row>
<row>
-<entry colname="col1">42Y05</entry>
-<entry colname="col2">There is no Foreign Key named '<<i>key</i>>'. </entry>
+<entry colname ="col1">42X38</entry>
+<entry colname ="col2">'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries.</entry>
</row>
<row>
-<entry colname="col1">42Y07</entry>
-<entry colname="col2">Schema '<<i>schemaName</i>>' does not exist.</entry>
+<entry colname ="col1">42X39</entry>
+<entry colname ="col2">Subquery is only allowed to return a single column.</entry>
</row>
<row>
-<entry colname="col1">42Y08</entry>
-<entry colname="col2">Foreign key constraints are not allowed on system tables. </entry>
+<entry colname ="col1">42X40</entry>
+<entry colname ="col2">A NOT statement has an operand that is not boolean . The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN. </entry>
</row>
<row>
-<entry colname="col1">42Y09</entry>
-<entry colname="col2">Void methods are only allowed within a CALL statement. </entry>
+<entry colname ="col1">42X41</entry>
+<entry colname ="col2">In the Properties clause of a FROM list, the property '{0}' is not valid (the property was being set to '{1}'). </entry>
</row>
<row>
-<entry colname="col1"> 42Y10</entry>
-<entry colname="col2">A table constructor that is not in an INSERT statement
-has all ? parameters in one of its columns. For each column, at least one
-of the rows must have a non-parameter.</entry>
+<entry colname ="col1">42X42</entry>
+<entry colname ="col2">Correlation name not allowed for column '{0}' because it is part of the FOR UPDATE list.</entry>
</row>
<row>
-<entry colname="col1">42Y11</entry>
-<entry colname="col2">A join specification is required with the '<<i>clauseName</i>>'
-clause. </entry>
+<entry colname ="col1">42X43</entry>
+<entry colname ="col2">The ResultSetMetaData returned for the class/object '{0}' was null. In order to use this class as an external virtual table, the ResultSetMetaData cannot be null. </entry>
</row>
<row>
-<entry colname="col1">42Y12</entry>
-<entry colname="col2">The ON clause of a JOIN is a '<<i>expressionType</i>>'
-expression. It must be a BOOLEAN expression. </entry>
+<entry colname ="col1">42X44</entry>
+<entry colname ="col2">Invalid length '{0}' in column specification.</entry>
</row>
<row>
-<entry colname="col1">42Y13</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' appears more than
-once in the CREATE VIEW statement.</entry>
+<entry colname ="col1">42X45</entry>
+<entry colname ="col2">{0} is an invalid type for argument number {1} of {2}.</entry>
</row>
<row>
-<entry colname="col1">42Y16</entry>
-<entry colname="col2">No public static method '<<i>methodName</i>>' was
-found in class '<<i>className</i>>'. The method might exist, but it is
-not public, or it is not static. </entry>
+<entry colname ="col1">42X46</entry>
+<entry colname ="col2">There are multiple functions named '{0}'. Use a the full signature or the specific name.</entry>
</row>
<row>
-<entry colname="col1">42Y19</entry>
-<entry colname="col2">'<<i>columnName</i>>' appears multiple times in the
-GROUP BY list. Columns in the GROUP BY list must be unambiguous. </entry>
+<entry colname ="col1">42X47</entry>
+<entry colname ="col2">There are multiple procedures named '{0}'. Use a the full signature or the specific name.</entry>
</row>
<row>
-<entry colname="col1">42Y22</entry>
-<entry colname="col2">Aggregate <<i>aggregateType</i>> cannot operate on
-type <<i>type</i>>. </entry>
+<entry colname ="col1">42X48</entry>
+<entry colname ="col2">Value '{1}' is not a valid precision for {0}.</entry>
</row>
<row>
-<entry colname="col1">42Y23</entry>
-<entry colname="col2">Incorrect JDBC type info returned for column <<i>columnName</i>>.
- </entry>
+<entry colname ="col1">42X49</entry>
+<entry colname ="col2">Value '{0}' is not a valid integer literal.</entry>
</row>
<row>
-<entry colname="col1">42Y24</entry>
-<entry colname="col2">View '<<i>viewName</i>>' is not updatable. (Views
-are currently not updatable.) </entry>
+<entry colname ="col1">42X50</entry>
+<entry colname ="col2">No method was found that matched the method call {0}.{1}({2}), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.</entry>
</row>
<row>
-<entry colname="col1">42Y25</entry>
-<entry colname="col2">'<<i>tableName</i>>' is a system table. Users are
-not allowed to modify the contents of this table. </entry>
+<entry colname ="col1">42X51</entry>
+<entry colname ="col2">The class '{0}' does not exist or is inaccessible. This can happen if the class is not public.</entry>
</row>
<row>
-<entry colname="col1">42Y27</entry>
-<entry colname="col2">Parameters are not allowed in the trigger action. </entry>
+<entry colname ="col1">42X52</entry>
+<entry colname ="col2">Calling method ('{0}') using a receiver of the Java primitive type '{1}" is not allowed.</entry>
</row>
<row>
-<entry colname="col1">42Y29</entry>
-<entry colname="col2">The SELECT list of a non-grouped query contains at least
-one invalid expression. When the SELECT list contains at least one aggregate
-then all entries must be valid aggregate expressions.</entry>
+<entry colname ="col1">42X53</entry>
+<entry colname ="col2">The LIKE predicate can only have 'CHAR' or 'VARCHAR' operands. Type '{0}' is not permitted.</entry>
</row>
<row>
-<entry colname="col1">42Y30</entry>
-<entry colname="col2">The SELECT list of a grouped query contains at least
-one invalid expression. If a SELECT list has a GROUP BY, the list may only
-contain grouping columns and valid aggregate expressions. </entry>
+<entry colname ="col1">42X54</entry>
+<entry colname ="col2">The Java method '{0}' has a ? as a receiver. This is not allowed.</entry>
</row>
<row>
-<entry colname="col1">42Y32</entry>
-<entry colname="col2">Aggregator class '<<i>className</i>> aggregate '<<i>aggregateName</i>>'
-on type <<i>type</i>> does not implement com.ibm.db2j.aggregates.Aggregator.
- </entry>
+<entry colname ="col1">42X55</entry>
+<entry colname ="col2">Table name '{1}' should be the same as '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42Y33</entry>
-<entry colname="col2">Aggregate <<i>aggregateName</i>> contains one or
-more aggregates. </entry>
+<entry colname ="col1">42X56</entry>
+<entry colname ="col2">The number of columns in the view column list does not match the number of columns in the underlying query expression in the view definition for '{0}'.</entry>
</row>
<row>
-<entry colname="col1">42Y34</entry>
-<entry colname="col2">Column name '<<i>columnName</i>>' matches more than
-one result column in table '<<i>tableName</i>>'. </entry>
+<entry colname ="col1">42X57</entry>
+<entry colname ="col2">The getColumnCount() for external virtual table '{0}' returned an invalid value '{1}'. Valid values are greater than or equal to 1. </entry>
</row>
<row>
-<entry colname="col1">42Y35</entry>
-<entry colname="col2">Column reference '<<i>reference</i>>' is invalid.
-When the SELECT list contains at least one aggregate then all entries must
-be valid aggregate expressions. </entry>
+<entry colname ="col1">42X58</entry>
+<entry colname ="col2">The number of columns on the left and right sides of the {0} must be the same.</entry>
</row>
<row>
-<entry colname="col1">42Y36</entry>
-<entry colname="col2">Column reference '<<i>value</i>>' is invalid. For
-a SELECT list with a GROUP BY, the list may only contain grouping columns
-and valid aggregate expressions. </entry>
+<entry colname ="col1">42X59</entry>
+<entry colname ="col2">The number of columns in each VALUES constructor must be the same.</entry>
</row>
<row>
-<entry colname="col1">42Y37</entry>
-<entry colname="col2">'<<i>value</i>>' is a Java primitive and cannot be
-used with this operator. </entry>
+<entry colname ="col1">42X60</entry>
+<entry colname ="col2">Invalid value '{0}' for insertMode property specified for table '{1}'.</entry>
</row>
<row>
-<entry colname="col1">42Y38</entry>
-<entry colname="col2"><codeblock>insertMode = replace</codeblock> is not permitted
-on an insert where the target table, '<<i>tableName</i>>', is referenced
-in the SELECT.</entry>
+<entry colname ="col1">42X61</entry>
+<entry colname ="col2">Types '{0}' and '{1}' are not {2} compatible.</entry>
</row>
<row>
-<entry colname="col1">42Y39</entry>
-<entry colname="col2">'<<i>value</i>>' may not appear in a CHECK CONSTRAINT
-definition because it may return non-deterministic results. </entry>
+<entry colname ="col1">42X62</entry>
+<entry colname ="col2">'{0}' is not allowed in the '{1}' schema.</entry>
</row>
<row>
-<entry colname="col1">42Y40</entry>
-<entry colname="col2">'<<i>value</i>>' appears multiple times in the UPDATE
-OF column list for trigger '<<i>triggerName</i>>'. </entry>
+<entry colname ="col1">42X63</entry>
+<entry colname ="col2">The USING clause did not return any results. No parameters can be set. </entry>
</row>
<row>
-<entry colname="col1">42Y41</entry>
-<entry colname="col2">'<<i>value</i>>' cannot be directly invoked via EXECUTE
-STATEMENT because it is part of a trigger. </entry>
+<entry colname ="col1">42X64</entry>
+<entry colname ="col2">In the Properties list, the invalid value '{0}' was specified for the useStatistics property. The only valid values are TRUE or FALSE. </entry>
</row>
<row>
-<entry colname="col1">42Y42</entry>
-<entry colname="col2">Scale '<<i>scaleValue</i>>' is not a valid scale
[... 4428 lines stripped ...]