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 fu...@apache.org on 2005/06/29 00:46:37 UTC
svn commit: r202296 [10/16] - in /incubator/derby/docs/trunk/src:
adminguide/ devguide/ getstart/ ref/ tools/ tuning/
Modified: incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita Tue Jun 28 15:46:15 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
@@ -14,15 +16,4595 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefexcept71493" xml:lang="en-us">
<title>SQLState and error message reference</title>
<refbody>
-<section> <ul>
-<li><xref href="rrefexcept13113.dita#rrefexcept13113"></xref></li>
-</ul></section>
+<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>:
+ </p></section>
+<section><table><title>Class Code 01: Warning</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">01003 </entry>
+<entry colname="col2">Null values were eliminated from the argument of a column
+function. </entry>
+<entry colname="col3">10000</entry>
+</row>
+<row>
+<entry colname="col1">0100E </entry>
+<entry colname="col2">XX Attempt to return too many result sets. </entry>
+<entry colname="col3">10000</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="col3">10000 </entry>
+</row>
+<row>
+<entry colname="col1">01501</entry>
+<entry colname="col2">The view <<i>viewName</i>> has been dropped. </entry>
+<entry colname="col3">10000</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="col3">10000 </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="col3">10000</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="col3">10000 </entry>
+</row>
+<row>
+<entry colname="col1">01505</entry>
+<entry colname="col2">The value <<i>valueName</i>> may be truncated.</entry>
+<entry colname="col3">10000</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="col3">10000</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="col3">10000 </entry>
+</row>
+<row>
+<entry colname="col1">01J02</entry>
+<entry colname="col2">Scroll sensitive cursors are not currently implemented. </entry>
+<entry colname="col3">10000 </entry>
+</row>
+<row>
+<entry colname="col1">01J03</entry>
+<entry colname="col2">Scroll sensitive and scroll insensitive updatable ResultSets
+are not currently implemented. </entry>
+<entry colname="col3">10000 </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="col3">10000 </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="col3">10000 </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="col3">10000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 04: Database authentication</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">04501</entry>
+<entry colname="col2">Database connection refused. </entry>
+<entry colname="col3">40000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title> Class Code 07: Dynamic SQL Error</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1"> 07009</entry>
+<entry colname="col2">No input parameters. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 08: Connection Exception</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">08000 </entry>
+<entry colname="col2">Connection closed by unknown interrupt. </entry>
+<entry colname="col3">40000 </entry>
+</row>
+<row>
+<entry colname="col1">08003</entry>
+<entry colname="col2">No current connection. </entry>
+<entry colname="col3">40000 </entry>
+</row>
+<row>
+<entry colname="col1">08004</entry>
+<entry colname="col2">Connection refused : <<i>connectionName</i>>
+ </entry>
+<entry colname="col3">40000 </entry>
+</row>
+<row>
+<entry colname="col1">08006</entry>
+<entry colname="col2">Database '<<i>databaseName</i>>'</entry>
+<entry colname="col3">45000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title> Class Code 0A: Feature Not Supported</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">0A000</entry>
+<entry colname="col2">Feature not implemented: <<i>featureName</i>>.</entry>
+<entry colname="col3">20000</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title> Class Code 21: Cardinality Violation</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title> Class Code 22: Data Exception</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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="col3">20000</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>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000</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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">22012</entry>
+<entry colname="col2">Attempt to divide by zero. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">22018</entry>
+<entry colname="col2">Invalid character string format for type <<i>typeName</i>>. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 23: Constraint Violation </title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 24: Invalid Cursor State</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">24000</entry>
+<entry colname="col2">Invalid cursor state - no current row. </entry>
+<entry colname="col3">20000</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 25: Invalid Transaction State</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">25000</entry>
+<entry colname="col2">Invalid transaction state. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 28: Invalid Authorization Specification</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">28502 </entry>
+<entry colname="col2">The user name '<<i>userName</i>>' is not valid.</entry>
+<entry colname="col3">40000 </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="col3">20000</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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 38: External Function Exception</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">38001 </entry>
+<entry colname="col2">The external routine is not allowed to execute SQL statements.
+ </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 39: External Function Exception</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 3B: Invalid SAVEPOINT</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">3B002</entry>
+<entry colname="col2">The maximum number of savepoints has been reached. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 40: Transaction Rollback</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">30000 </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="col3">30000</entry>
+</row>
+<row>
+<entry colname="col1">40XD0</entry>
+<entry colname="col2">Container has been closed. </entry>
+<entry colname="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XD1</entry>
+<entry colname="col2">Container was opened in read-only mode. </entry>
+<entry colname="col3">30000</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="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XL1</entry>
+<entry colname="col2">A lock could not be obtained within the time requested.</entry>
+<entry colname="col3">30000 </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="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XT0</entry>
+<entry colname="col2">An internal error was identified by RawStore module. </entry>
+<entry colname="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XT1</entry>
+<entry colname="col2">An exception was thrown during transaction commit.</entry>
+<entry colname="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XT2</entry>
+<entry colname="col2">An exception was thrown during rollback of a SAVEPOINT. </entry>
+<entry colname="col3">30000 </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="col3">30000 </entry>
+</row>
+<row>
+<entry colname="col1">40XT5</entry>
+<entry colname="col2">Exception thrown during an internal transaction. </entry>
+<entry colname="col3">30000 </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="col3">30000</entry>
+</row>
+<row>
+<entry colname="col1">40XT7</entry>
+<entry colname="col2">Operation is not supported in an internal transaction.
+ </entry>
+<entry colname="col3">30000</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code 42: Syntax Error or Access Rule Violation</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</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>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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>
+<entry colname="col3">20000 </entry>
+</row>
+<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="col3">20000 </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="col3">20000 </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>
+<entry colname="col3">20000 </entry>
+</row>
+<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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42815</entry>
+<entry colname="col2">The replacement value for '<<i>value</i>>' is invalid. </entry>
+<entry colname="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42818</entry>
+<entry colname="col2">Comparisons between '<<i>value</i>>' and '<<i>value</i>>'
+are not supported. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42820</entry>
+<entry colname="col2">The floating point literal '<<i>string</i>>' contains
+more than 30 characters. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42846</entry>
+<entry colname="col2">Cannot convert types '<<i>type</i>>' to '<<i>type</i>>'. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">428C1</entry>
+<entry colname="col2">Only one identity column is allowed in a table.</entry>
+<entry colname="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42903</entry>
+<entry colname="col2">Invalid use of an aggregate function. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42908</entry>
+<entry colname="col2">The CREATE VIEW statement does not include a column
+list. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42915 </entry>
+<entry colname="col2">Foreign Key '<<i>key</i>>' is invalid because '<<i>value</i>>'.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<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="col3">20000</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="col3">20000 </entry>
+</row>
+<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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42995</entry>
+<entry colname="col2">The requested function does not apply to global temporary
+tables. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X01 </entry>
+<entry colname="col2">Syntax error: <<i>error</i>>. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42X02</entry>
+<entry colname="col2"><<i>value</i>>. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X05</entry>
+<entry colname="col2">Table '<<i>tableName</i>>' does not exist. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X06</entry>
+<entry colname="col2">Too many result columns specified for table '<<i>tableName</i>>'.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X07</entry>
+<entry colname="col2">Null is only allowed in a VALUES clause within an INSERT
+statement. </entry>
+<entry colname="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X23</entry>
+<entry colname="col2">Cursor <<i>cursorName</i>> is not updatable. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000</entry>
+</row>
+<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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42X38</entry>
+<entry colname="col2">'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X39</entry>
+<entry colname="col2">Subquery is only allowed to return a single column. </entry>
+<entry colname="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000</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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X44 </entry>
+<entry colname="col2">Invalid length '<<i>length</i>>' in column specification.
+ </entry>
+<entry colname="col3">20000 </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="col3">20000</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="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42X49</entry>
+<entry colname="col2">Value '<<i>value</i>>' is not a valid integer literal.</entry>
+<entry colname="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000</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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X65</entry>
+<entry colname="col2">Index '<<i>index</i>>' does not exist. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X74</entry>
+<entry colname="col2">Invalid CALL statement syntax.</entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000</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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X94</entry>
+<entry colname="col2"><<i>value</i>> '<<i>value</i>>' does not exist.</entry>
+<entry colname="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42X98</entry>
+<entry colname="col2">Parameters are not allowed in a VIEW definition. </entry>
+<entry colname="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y01</entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid.
+ </entry>
+<entry colname="col3">20000</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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y05</entry>
+<entry colname="col2">There is no Foreign Key named '<<i>key</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y07</entry>
+<entry colname="col2">Schema '<<i>schemaName</i>>' does not exist.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y08</entry>
+<entry colname="col2">Foreign key constraints are not allowed on system tables. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y09</entry>
+<entry colname="col2">Void methods are only allowed within a CALL statement. </entry>
+<entry colname="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y23</entry>
+<entry colname="col2">Incorrect JDBC type info returned for column <<i>columnName</i>>.
+ </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y27</entry>
+<entry colname="col2">Parameters are not allowed in the trigger action. </entry>
+<entry colname="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y33</entry>
+<entry colname="col2">Aggregate <<i>aggregateName</i>> contains one or
+more aggregates. </entry>
+<entry colname="col3">20000 </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="col3">20000 </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="col3">20000</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="col3">20000 </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="col3">20000</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="col3">20000</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="col3">20000 </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="col3">20000 </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="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y42</entry>
+<entry colname="col2">Scale '<<i>scaleValue</i>>' is not a valid scale
+for a <<i>value</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y43</entry>
+<entry colname="col2">Scale '<<i>scaleValue</i>>' is not a valid scale
+with precision of '<<i>precision</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y44</entry>
+<entry colname="col2">Invalid key '<<i>key</i>>' specified in the Properties
+list of a FROM list. The case-sensitive keys that are currently supported
+are '<<i>key</i>>'. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y45</entry>
+<entry colname="col2">VTI '<<i>value</i>>' cannot be bound because it is
+a special trigger VTI and this statement is not part of a trigger action or
+WHEN clause.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y46</entry>
+<entry colname="col2">Invalid Properties list in FROM list. There is no index
+'<<i>index</i>>' on table '<<i>tableName</i>>'.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y48</entry>
+<entry colname="col2">Invalid Properties list in FROM list. Either there
+is no named constraint '<<i>constraintName</i>>' on table '<<i>tableName</i>>'
+or the constraint does not have a backing index. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y49</entry>
+<entry colname="col2">Multiple values specified for property key '<<i>key</i>>'.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y50</entry>
+<entry colname="col2">Properties list for table '<<i>tableName</i>>' may
+contain values for index or for constraint but not both. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y55</entry>
+<entry colname="col2">'<<i>value</i>>' cannot be performed on '<<i>value</i>>'
+because it does not exist. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y56</entry>
+<entry colname="col2">Invalid join strategy '<<i>strategyValue</i>>' specified
+in Properties list on table '<<i>tableName</i>>'. The currently supported
+values for a join strategy are: <codeblock>hash</codeblock> and <codeblock>nestedloop</codeblock>.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y58</entry>
+<entry colname="col2">NumberFormatException occurred when converting value
+'<<i>value</i>>' for optimizer override '<<i>value</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y59</entry>
+<entry colname="col2">Invalid value, '<<i>value</i>>', specified for hashInitialCapacity
+override. Value must be greater than 0. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y60</entry>
+<entry colname="col2">Invalid value, '<<i>value</i>>', specified for hashLoadFactor
+override. Value must be greater than 0.0 and less than or equal to 1.0. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y61</entry>
+<entry colname="col2">Invalid value, '<<i>value</i>>' specified for hashMaxCapacity
+override. Value must be greater than 0. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y62</entry>
+<entry colname="col2">'<<i>value</i>>' is not allowed on '<<i>value</i>>'
+because it is a view. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y63</entry>
+<entry colname="col2">Hash join requires an optimizable equijoin predicate
+on a column in the selected index or heap. An optimizable equijoin predicate
+does not exist on any column in table or index '<<i>index</i>>'. Use the
+'index' optimizer override to specify such an index or the heap on table '<<i>tableName</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y64</entry>
+<entry colname="col2">bulkFetch value of '<<i>value</i>>' is invalid. The
+minimum value for bulkFetch is 1. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y65</entry>
+<entry colname="col2">bulkFetch is not permitted on '<<i>joinType</i>>'
+joins. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y66</entry>
+<entry colname="col2">bulkFetch is not permitted on updatable cursors. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y67</entry>
+<entry colname="col2">Schema '<<i>schemaName</i>>' cannot be dropped.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y69 </entry>
+<entry colname="col2">No valid execution plan was found for this statement.
+This may have one of two causes: either you specified a hash join strategy
+when hash join is not allowed (no optimizable equijoin) or you are attempting
+to join two external virtual tables, each of which references the other, and
+so the statement cannot be evaluated. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1"> 42Y70</entry>
+<entry colname="col2">The user specified an illegal join order. This could
+be caused by a join column from an inner table being passed as a parameter
+to an external virtual table. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y71</entry>
+<entry colname="col2">System function or procedure '<<i>procedureName</i>>'
+cannot be dropped.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y82</entry>
+<entry colname="col2">System generated stored prepared statement '<<i>statement</i>>'
+that cannot be dropped using DROP STATEMENT. It is part of a trigger. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1"> 42Y83</entry>
+<entry colname="col2">An untyped null is not permitted as an argument to aggregate <<i>aggregateName</i>>.
+ Please cast the null to a suitable type. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y84</entry>
+<entry colname="col2">'<<i>value</i>>' may not appear in a DEFAULT definition.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y85</entry>
+<entry colname="col2">The DEFAULT keyword is only allowed in a VALUES clause
+when the VALUES clause appears within an INSERT statement. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y90</entry>
+<entry colname="col2">FOR UPDATE is not permitted in this type of statement.
+ </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y91</entry>
+<entry colname="col2">The USING clause is not permitted in an EXECUTE STATEMENT
+for a trigger action. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y92</entry>
+<entry colname="col2"><<i>triggerName</i>> triggers may only reference <<i>value</i>>
+transition variables/tables. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y93</entry>
+<entry colname="col2">Illegal REFERENCING clause: only one name is permitted
+for each type of transition variable/table. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Y94</entry>
+<entry colname="col2">An AND or OR has a non-boolean operand. The operands
+of AND and OR must evaluate to TRUE, FALSE, or UNKNOWN. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y95</entry>
+<entry colname="col2">The '<<i>operatorName</i>>' operator with a left
+operand type of '<<i>operandType</i>>' and a right operand type of '<<i>operandType</i>>'
+is not supported. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Y97</entry>
+<entry colname="col2">Invalid escape character at line '<<i>lineNumber</i>>',
+column '<<i>columnName</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z02</entry>
+<entry colname="col2">Multiple DISTINCT aggregates are not supported at this
+time. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z07</entry>
+<entry colname="col2">Aggregates are not permitted in the ON clause. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z08</entry>
+<entry colname="col2">Bulk insert replace is not permitted on '<<i>value</i>>'
+because it has an enabled trigger (<<i>value</i>>). </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z15</entry>
+<entry colname="col2">Invalid type specified for column '<<i>columnName</i>>'.
+The type of a column may not be changed. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z16</entry>
+<entry colname="col2">Only columns of type VARCHAR may have their length altered. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z17</entry>
+<entry colname="col2">Invalid length specified for column '<<i>columnName</i>>'.
+Length must be greater than the current column length. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z18</entry>
+<entry colname="col2">Column '<<i>columnName</i>>' is part of a foreign
+key constraint '<<i>constraintName</i>>'. To alter the length of this column,
+you should drop the constraint first, perform the ALTER TABLE, and then recreate
+the constraint.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z19</entry>
+<entry colname="col2">Column '<<i>columnName</i>>' is being referenced
+by at least one foreign key constraint '<<i>constraintName</i>>'. To alter
+the length of this column, you should drop referencing constraints, perform
+the ALTER TABLE, and then recreate the constraints. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z20</entry>
+<entry colname="col2">Column '<<i>columnName</i>>' cannot be made nullable.
+It is part of a primary key, which cannot have any nullable columns. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z21</entry>
+<entry colname="col2">Invalid increment specified for identity for column
+'<<i>columnName</i>>'. Increment cannot be zero. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z22</entry>
+<entry colname="col2">Invalid type specified for identity column '<<i>columnName</i>>'.
+The only valid types for identity columns are BIGINT, INT and SMALLINT. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z23</entry>
+<entry colname="col2">Attempt to modify an identity column '<<i>columnName</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z24</entry>
+<entry colname="col2">Overflow occurred in identity value for column '<<i>columnName</i>>'
+in table '<<i>tableName</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1"> 42Z25</entry>
+<entry colname="col2">INTERNAL ERROR identity counter. Update was called without
+ arguments with <codeblock>current value = NULL</codeblock>. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z26</entry>
+<entry colname="col2">A column, '<<i>columnName</i>>', with an identity
+default cannot be made nullable. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z27</entry>
+<entry colname="col2">A nullable column, '<<i>columnName</i>>', cannot
+be modified to have identity default. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z50</entry>
+<entry colname="col2">INTERNAL ERROR: Unable to generate code for <<i>value</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z53</entry>
+<entry colname="col2">INTERNAL ERROR: Do not know what type of activation
+to generate for node choice <<i>value</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z90</entry>
+<entry colname="col2">Class '<<i>className</i>>' does not return an updatable
+ResultSet. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z91</entry>
+<entry colname="col2">subquery</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z92</entry>
+<entry colname="col2">repeatable read</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z93</entry>
+<entry colname="col2">Constraints '<<i>constraintName</i>>' and '<<i>constraintName</i>>'
+have the same set of columns, which is not allowed. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z97</entry>
+<entry colname="col2">Renaming column '<<i>columnName</i>>' will cause
+check constraint '<<i>constraintName</i>>' to break.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z99</entry>
+<entry colname="col2">String or Hex literal cannot exceed 64K.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z9A</entry>
+<entry colname="col2">read uncommitted</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">42Z9B</entry>
+<entry colname="col2">The external virtual table interface does not support
+BLOB or CLOB columns. '<<i>value</i>>' column '<<i>value</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z9D</entry>
+<entry colname="col2">'<<i>statement</i>>' statements are not allowed in
+'<<i>triggerName</i>>' triggers. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z9E</entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is not a <<i>value</i>>
+constraint. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">42Z9F</entry>
+<entry colname="col2">Too many indexes (<<i>index</i>>) on the table <<i>tableName</i>>.
+The limit is <<i>number</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code XOX: Execution exceptions</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLState</entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">X0X02</entry>
+<entry colname="col2">Table '<<i>tableName</i>>' cannot be locked in '<<i>mode</i>>'
+mode. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X03</entry>
+<entry colname="col2">Invalid transaction state - held cursor requires same
+isolation level </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X05</entry>
+<entry colname="col2">Table '<<i>tableName</i>>' does not exist. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X07</entry>
+<entry colname="col2">Cannot drop jar file '<<i>fileName</i>>' because
+its on your db2j.database.classpath '<<i>classpath</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X0E</entry>
+<entry colname="col2">The column position '<<i>columnPosition</i>>' listed
+in the auto-generated column selection array was not found in the insert table. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X0F</entry>
+<entry colname="col2">Column name '<<i>columnName</i>>' listed in auto-generated
+column selection array not found in the insert table. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X10</entry>
+<entry colname="col2">The USING clause returned more than one row; only single-row
+ResultSets are permissible.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X11</entry>
+<entry colname="col2">The USING clause did not return any results so no parameters
+can be set. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X13 </entry>
+<entry colname="col2">Jar file '<<i>fileName</i>>' does not exist in schema
+'<<i>schemaName</i>>'. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X14</entry>
+<entry colname="col2">Binding directly to an XML value is not allowed; try
+using XMLPARSE.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X15</entry>
+<entry colname="col2">XML values are not allowed in top-level result sets;
+try using XMLSERIALIZE.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X16</entry>
+<entry colname="col2">XML syntax error; missing keyword(s): '<<i>keywords</i>>'.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X17</entry>
+<entry colname="col2">Invalid target type for XMLSERIALIZE: '<<i>value</i>>'.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X18</entry>
+<entry colname="col2">XML feature not supported: '<<i>featureName</i>>'.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X57</entry>
+<entry colname="col2">An attempt was made to put a Java value of type '<<i>type</i>>'
+into a SQL value, but there is no corresponding SQL type. The Java value
+is probably the result of a method call or field access. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X60</entry>
+<entry colname="col2">A cursor with name '<<i>cursorName</i>>' already
+exists. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X61</entry>
+<entry colname="col2">The values for column '<<i>value</i>>' in index '<<i>value</i>>'
+and table '<<i>value</i>>.<<i>value</i>>' do not match for row location <<i>value</i>>.
+ The value in the index is '<<i>value</i>>', while the value in the base
+table is '<<i>value</i>>'. The full index key, including the row location,
+is '<<i>value</i>>'. The suggested corrective action is to recreate the
+index. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X62</entry>
+<entry colname="col2">Inconsistency found between table '<<i>tableName</i>>'
+and index '<<i>index</i>>'. Error when trying to retrieve row location
+'<<i>rowLocation</i>>' from the table. The full index key, including the
+row location, is '<<i>index</i>>'. The suggested corrective action is to
+recreate the index. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X63</entry>
+<entry colname="col2">Got IOException '<<i>value</i>>'.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X67</entry>
+<entry colname="col2">Columns of type '<<i>type</i>>' may not be used in
+CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
+because comparisons are not supported for that type.</entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0X81</entry>
+<entry colname="col2"><<i>value</i>> '<<i>value</i>>' does not exist.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X85</entry>
+<entry colname="col2">Index '<<i>index</i>>' was not created because '<<i>type</i>>'
+is not a valid index type. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X86</entry>
+<entry colname="col2">0 is an invalid parameter value for <codeblock>ResultSet.absolute(int row)</codeblock>.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X87</entry>
+<entry colname="col2"><codeblock>ResultSet.relative(int row)</codeblock> cannot
+be called when the cursor is not positioned on a row. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X95</entry>
+<entry colname="col2">Operation '<<i>operation</i>>' cannot be performed
+on object '<<i>object</i>>' because there is an open ResultSet dependent
+on that object. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0X99</entry>
+<entry colname="col2">Index '<<i>index</i>>' does not exist. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0XML</entry>
+<entry colname="col2">Encountered unexpected error while processing XML; see
+next exception for details.</entry>
+<entry colname="col3">20000</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code X0Y: Execution exceptions</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="128*"/><colspec colname="col2"
+colwidth="674*"/><colspec colname="col3" colwidth="97*"/>
+<thead>
+<row>
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row valign="top">
+<entry colname="col1">X0Y16</entry>
+<entry colname="col2">'<<i>value</i>>' is not a view. If it is a table,
+then use DROP TABLE instead. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y23</entry>
+<entry colname="col2">Operation '<<i>operation</i>>' cannot be performed
+on object '<<i>object</i>>' because VIEW '<<i>viewName</i>>' is dependent
+on that object. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y24</entry>
+<entry colname="col2">Operation '<<i>operation</i>>' cannot be performed
+on object '<<i>object</i>>' because STATEMENT '<<i>statement</i>>' is
+dependent on that object.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y25</entry>
+<entry colname="col2">Operation '<<i>value</i>>' cannot be performed on
+object '<<i>value</i>>' because <<i>value</i>> '<<i>value</i>>' is
+dependent on that object. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y26 </entry>
+<entry colname="col2">Index '<<i>index</i>>' is required to be in the same
+schema as table '<<i>tableName</i>>'. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y28</entry>
+<entry colname="col2">Index '<<i>index</i>>' cannot be created on system
+table '<<i>tableName</i>>'. Users cannot create indexes on system tables. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y32</entry>
+<entry colname="col2"><<i>value</i>> '<<i>value</i>>' already exists
+in <<i>value</i>> '<<i>value</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y38 </entry>
+<entry colname="col2">Cannot create index '<<i>index</i>>' because table
+'<<i>tableName</i>>' does not exist. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y41</entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid because
+the referenced table <<i>tableName</i>> has no primary key. Either add
+a primary key to <<i>tableName</i>> or explicitly specify the columns of
+a unique constraint that this foreign key references. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y42</entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid:
+the types of the foreign key columns do not match the types of the referenced
+columns</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y43</entry>
+<entry colname="col2">Constraint '<<i>value</i>>' is invalid: the number
+of columns in <<i>value</i>> (<<i>value</i>>) does not match the number
+of columns in the referenced key (<<i>value</i>>). </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y44 </entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid:
+there is no unique or primary key constraint on table '<<i>tableName</i>>'
+that matches the number and types of the columns in the foreign key.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y45 </entry>
+<entry colname="col2">Foreign key constraint '<<i>constraintName</i>>'
+cannot be added to or enabled on table <<i>tableName</i>> because one or
+more foreign keys do not have matching referenced keys. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y46</entry>
+<entry colname="col2">Constraint '<<i>constraintName</i>>' is invalid:
+referenced table <<i>tableName</i>> does not exist. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y54</entry>
+<entry colname="col2">Schema '<<i>schemaName</i>>' cannot be dropped because
+it is not empty. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y55 </entry>
+<entry colname="col2">The number of rows in the base table does not match
+the number of rows in at least 1 of the indexes on the table. Index '<<i>value</i>>'
+on table '<<i>value</i>>.<<i>value</i>>' has <<i>value</i>> rows,
+but the base table has <<i>value</i>> rows. The suggested corrective action
+is to recreate the index. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y56</entry>
+<entry colname="col2">'<<i>value</i>>' is not allowed on the System table
+'<<i>value</i>>'.</entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y57</entry>
+<entry colname="col2">A non-nullable column cannot be added to table '<<i>tableName</i>>'
+because the table contains at least one row. Non-nullable columns can only
+be added to empty tables. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y58</entry>
+<entry colname="col2">Attempt to add a primary key constraint to table '<<i>tableName</i>>'
+failed because the table already has a constraint of that type. A table can
+only have a single primary key constraint. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y59 </entry>
+<entry colname="col2">Attempt to add or enable constraint(s) on table '<<i>tableName</i>>'
+failed because the table contains <<i>rowName</i>> row(s) that violate
+the following check constraint(s): <<i>constraintName</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y63</entry>
+<entry colname="col2">The command on table '<<i>tableName</i>>' failed
+because null data was found in the primary key or unique constraint/index
+column(s). All columns in a primary or unique index key must not be null.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y66 </entry>
+<entry colname="col2">Cannot issue commit in a nested connection when there
+is a pending operation in the parent connection. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y67 </entry>
+<entry colname="col2">Cannot issue rollback in a nested connection when there
+is a pending operation in the parent connection. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y68 </entry>
+<entry colname="col2"><<i>value</i>> '<<i>value</i>>' already exists.
+ </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y69</entry>
+<entry colname="col2"><<i>value</i>> is not permitted because trigger <<i>triggerName</i>>
+is active on <<i>value</i>>. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y70 </entry>
+<entry colname="col2">INSERT, UPDATE and DELETE are not permitted on table <<i>tableName</i>>
+because trigger <<i>triggerName</i>> is active. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y71</entry>
+<entry colname="col2">Transaction manipulation such as SET ISOLATION is not
+permitted because trigger <<i>triggerName</i>> is active. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y72</entry>
+<entry colname="col2">Bulk insert replace is not permitted on '<<i>value</i>>'
+because it has an enabled trigger (<<i>value</i>>). </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y77</entry>
+<entry colname="col2">Cannot issue set transaction isolation statement on
+a global transaction that is in progress because it would have implicitly
+committed the global transaction. </entry>
+<entry colname="col3">20000</entry>
+</row>
+<row>
+<entry colname="col1">X0Y78</entry>
+<entry colname="col2">Statement.executeQuery() cannot be called with a statement
+that returns a row count. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y79</entry>
+<entry colname="col2">Statement.executeUpdate() cannot be called with a statement
+that returns a ResultSet. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y80 </entry>
+<entry colname="col2">ALTER table '<<i>tableName</i>>' failed. Null data
+found in column '<<i>columnName</i>>'. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+<row>
+<entry colname="col1">X0Y83
+ </entry>
+<entry colname="col2">WARNING: While deleting a row from a table the index
+row for base table row <<i>rowName</i>> was not found in index with conglomerate
+id <<i>id</i>>. This problem has automatically been corrected as part
+of the delete operation. </entry>
+<entry colname="col3">20000 </entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Class Code XBCA: CacheService</title>
+<tgroup cols="3"><colspec colname="col1" colwidth="128*"/><colspec colname="col2"
+colwidth="674*"/><colspec colname="col3" colwidth="97*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">SQLSTATE </entry>
+<entry colname="col2">Message Text</entry>
+<entry colname="col3">Severity</entry>
+</row>
+</thead>
+<tbody>
+<row>
[... 2199 lines stripped ...]