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/07/01 02:14:52 UTC
svn commit: r208698 [3/6] - /incubator/derby/docs/trunk/src/ref/
Modified: incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefexcept71493.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -20,16 +20,16 @@
<title>SQLState and error message reference</title>
<refbody>
<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>
+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="3"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
-colwidth="673*"/><colspec colname="col3" colwidth="96*"/>
+<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/>
<thead>
<row valign="bottom">
<entry colname="col1">SQLSTATE</entry>
<entry colname="col2">Message Text</entry>
-<entry colname="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -37,118 +37,100 @@
<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*"/>
+<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="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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -156,100 +138,87 @@
<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*"/>
+<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="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*"/>
+<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="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*"/>
+<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="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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -257,60 +226,50 @@
<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>
@@ -318,7 +277,6 @@
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>
@@ -326,50 +284,43 @@
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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -377,98 +328,85 @@
<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*"/>
+<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="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*"/>
+<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="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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -476,35 +414,30 @@
<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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -512,36 +445,31 @@
<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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -549,18 +477,16 @@
<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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -568,35 +494,30 @@
<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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -604,89 +525,74 @@
<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*"/>
+<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="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -694,236 +600,197 @@
<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>
+<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>
</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>
@@ -932,222 +799,185 @@
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>
@@ -1156,545 +986,456 @@
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>
@@ -1702,29 +1443,24 @@
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>
@@ -1733,121 +1469,101 @@
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>
@@ -1855,7 +1571,6 @@
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>
@@ -1863,138 +1578,115 @@
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*"/>
+<tgroup cols="2"><colspec colname="col1" colwidth="129*"/><colspec colname="col2"
+colwidth="673*"/>
<thead>
<row valign="bottom">
<entry colname="col1">SQLState</entry>
<entry colname="col2">Message Text</entry>
-<entry colname="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -2002,94 +1694,78 @@
<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>
@@ -2099,7 +1775,6 @@
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>
@@ -2108,72 +1783,61 @@
'<<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*"/>
+<tgroup cols="2"><colspec colname="col1" colwidth="128*"/><colspec colname="col2"
+colwidth="674*"/>
<thead>
<row>
<entry colname="col1">SQLSTATE </entry>
<entry colname="col2">Message Text</entry>
-<entry colname="col3">Severity</entry>
</row>
</thead>
<tbody>
@@ -2181,52 +1845,44 @@
<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>
@@ -2234,21 +1890,18 @@
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>
@@ -2256,26 +1909,22 @@
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>
@@ -2284,34 +1933,29 @@
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>
@@ -2319,74 +1963,62 @@
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
[... 2268 lines stripped ...]