SQL error messages and exceptions

Class Code 01: Warning - - - -SQLSTATE -Message Text -Severity - - - - -01003 -Null values were eliminated from the argument of a column -function. -10000 - - -0100E -XX Attempt to return too many result sets. -10000 - - -01500 -The constraint <constraintName> on table <tableName> -has been dropped. -10000 - - -01501 -The view <viewName> has been dropped. -10000 - - -01502 -The trigger <triggerName> on table <tableName> -has been dropped. -10000 - - -01503 -The column <columnName> on table <tableName> -has been modified by adding a not null constraint. -10000 - - -01504 -The new index is a duplicate of an existing index: <index>. - -10000 - - -01505 -The value <valueName> may be truncated. -10000 - - -01522 -The newly defined synonym '<synonymName>' -resolved to the object '<objectName>' which is currently undefined. -10000 - - -01J01 -Database '<databaseName>' not created, connection -made to existing database instead. -10000 - - -01J02 -Scroll sensitive cursors are not currently implemented. -10000 - - -01J03 -Scroll sensitive and scroll insensitive updatable ResultSets -are not currently implemented. -10000 - - -01J04 -The class '<className>' for column '<columnName>' -does not implement java.io.Serializable or java.sql.SQLData. Instances must -implement one of these interfaces to allow them to be stored. -10000 - - -01J05 -Database upgrade succeeded. The upgraded database is -now ready for use. Revalidating stored prepared statements failed. See next -exception for details about failure. -10000 - - -01J06 -ResultSet not updatable. Query does not qualify to generate -an updatable ResultSet. -10000 - - - -

Class Code 04: Database authentication - - - -SQLSTATE -Message Text -Severity - - - - -04501 -Database connection refused. -40000 - - - -

Class Code 07: Dynamic SQL Error - - - -SQLSTATE -Message Text -Severity - - - - -07000 -At least one parameter to the current statement is uninitialized. - -20000 - - -07004 -Parameter <parameterName> is a <procedureName> -procedure parameter and must be registered with CallableStatement.registerOutParameter -before execution. -20000 - - - 07009 -No input parameters. -20000 - - - -

Class Code 08: Connection Exception - - - -SQLSTATE -Message Text -Severity - - - - -08000 -Connection closed by unknown interrupt. -40000 - - -08003 -No current connection. -40000 - - -08004 -Connection refused : <connectionName> - -40000 - - -08006 -Database '<databaseName>' -45000 - - - -

Class Code 0A: Feature Not Supported - - - -SQLSTATE -Message Text -Severity - - - - -0A000 -Feature not implemented: <featureName>. -20000 - - - -

Class Code 21: Cardinality Violation - - - -SQLSTATE -Message Text -Severity - - - - -21000 -Scalar subquery is only allowed to return a single row. -20000 - - - -

Class Code 22: Data Exception - - - -SQLSTATE -Message Text -Severity - - - - -2200L -XMLPARSE operand is not an XML document; see next exception -for details. -20000 - - -22001 -A truncation error was encountered trying to shrink <value> -'<value>' to length <value> -20000 - - -22003 -The resulting value is outside the range for the data -type <datatypeName>. -20000 - - -22005 -An attempt was made to get a data value of type '<typeName>' -from a data value of type '<typeName>'. -20000 - - -22007 -The string representation of a datetime value is out -of range. -20000 - - -22007 -The syntax of the string representation of a datetime -value is incorrect. -20000 - - -22008 -'<argument>' is an invalid argument to the <functionName> -function. -20000 - - -22011 -The second or third argument of the SUBSTR function -is out of range. -20000 - - -22012 -Attempt to divide by zero. -20000 - - -22013 -Attempt to take the square root of a negative number, -'<number>'. -20000 - - -22014 -The start position for LOCATE is invalid; it must be -a positive integer. The index to start the search from is '<index>'. - The string to search for is '<index>'. The string to search from -is '<index>'. -20000 - - -22015 -The '<functionName>' function is not allowed -on the following set of types. First operand is of type '<typeName>'. -Second operand is of type '<typeName>'. Third operand (start position) -is of type '<typeName>'. -20000 - - -22018 -Invalid character string format for type <typeName>. -20000 - - -22019 -Invalid escape sequence, '<sequenceName>'. -The escape string must be exactly one character. It cannot be a null or more -than one character. -20000 - - -22025 -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. -20000 - - -22027 -The built-in TRIM() function only supports a single -trim character. The LTRIM() and RTRIM() built-in functions support multiple -trim characters. -20000 - - -22501 -An ESCAPE clause of NULL returns undefined results and -is not allowed. -20000 - - - -

Class Code 23: Constraint Violation - - - -SQLSTATE -Message Text -Severity - - - - -23502 -Column '<columnName>' cannot accept a NULL -value. -20000 - - -23503 -<value> on table '<tableName>' caused -a violation of foreign key constraint '<constraintName>' for key <keyName>. -The statement has been rolled back. -20000 - - -23505 -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 '<value>' defined on '<value>'. -20000 - - -23513 -The check constraint '<constraintName>' was -violated while performing an INSERT or UPDATE on table '<tableName>'. -20000 - - - -

Class Code 24: Invalid Cursor State - - - -SQLSTATE -Message Text -Severity - - - - -24000 -Invalid cursor state - no current row. -20000 - - - -

Class Code 25: Invalid Transaction State - - - -SQLSTATE -Message Text -Severity - - - - -25000 -Invalid transaction state. -20000 - - -25501 -Unable to set the connection read-only property in an -active transaction. -20000 - - -25502 -An SQL data change is not permitted for a read-only -connection, user or database. -20000 - - -25503 -DDL is not permitted for a read-only connection, user -or database. -20000 - - - 25505 -A read-only user or a user in a read-only database is -not permitted to disable read-only mode on a connection. -20000 - - - -

Class Code 28: Invalid Authorization Specification - - - -SQLSTATE -Message Text -Severity - - - - -28501 -Invalid database authorization property '<value>=<value>'. - -20000 - - -28502 -The user name '<userName>' is not valid. -40000 - - -28503 -User(s) '<userName>' must not be in both read-only -and full-access authorization lists. -20000 - - -28504 -Repeated user(s) '<userName>' in access list -'<listName>'. -20000 - - - -

Class Code 38: External Function Exception - - - -SQLSTATE -Message Text -Severity - - - - -38000 -The exception '<exception>' was thrown while -evaluating an expression. -20000 - - -38001 -The external routine is not allowed to execute SQL statements. - -20000 - - -38002 -The routine attempted to modify data, but the routine -was not defined as MODIFIES SQL DATA. -20000 - - -38004 -The routine attempted to read data, but the routine -was not defined as READS SQL DATA. -20000 - - - -

Class Code 39: External Function Exception - - - -SQLSTATE -Message Text -Severity - - - - -39004 -A NULL value cannot be passed to a method which takes -a parameter of primitive type '<type>'. -20000 - - - -

Class Code 3B: Invalid SAVEPOINT - - - -SQLSTATE -Message Text -Severity - - - - -3B001 -SAVEPOINT, <savepoint> does not exist or -is not active in the current transaction. -20000 - - -3B002 -The maximum number of savepoints has been reached. -20000 - - - 3B501 -A SAVEPOINT with the passed name already exists in the -current transaction. -20000 - - -3B502 -A RELEASE or ROLLBACK TO SAVEPOINT was specified, but -the savepoint does not exist. -20000 - - - -

Class Code 40: Transaction Rollback - - - -SQLSTATE -Message Text -Severity - - - - -40001 -A lock could not be obtained due to a deadlock, cycle -of locks and waiters is: <value>. The selected victim is XID : <value>. -30000 - - -40XC0 -Dead statement. This may be caused by catching a transaction -severity error inside this statement. -30000 - - -40XD0 -Container has been closed. -30000 - - -40XD1 -Container was opened in read-only mode. -30000 - - -40XD2 -Container <containerName> cannot be opened; -it either has been dropped or does not exist. -30000 - - -40XL1 -A lock could not be obtained within the time requested. -30000 - - -40XL2 -A lock could not be obtained within the time requested. - The lockTable dump is: <tableDump>. -30000 - - -40XT0 -An internal error was identified by RawStore module. -30000 - - -40XT1 -An exception was thrown during transaction commit. -30000 - - -40XT2 -An exception was thrown during rollback of a SAVEPOINT. -30000 - - -40XT4 -An attempt was made to close a transaction that was -still active. The transaction has been aborted. -30000 - - -40XT5 -Exception thrown during an internal transaction. -30000 - - -40XT6 -Database is in quiescent state, cannot activate transaction. - Please wait for a moment until it exits the inactive state. -30000 - - -40XT7 -Operation is not supported in an internal transaction. - -30000 - - - -

Class Code 42: Syntax Error or Access Rule Violation - - - -SQLSTATE -Message Text -Severity - - - - -42000 -Syntax error or access rule violation; see additional -errors for details. -20000 - - -42601 -ALTER TABLE statement cannot add an IDENTITY column -to a table. -20000 - - -42601 -ALTER TABLE statement cannot add an IDENTITY column -to a table. -20000 - - -42605 -The number of arguments for function '<functionName>' -is incorrect. -20000 - - -42606 -An invalid hexadecimal constant starting with '<number>' -has been detected. -20000 - - -42610 -All the arguments to the COALESCE/VALUE function cannot -be parameters. The function needs at least one argument that is not a parameter. -20000 - - -42611 -The length, precision, or scale attribute for column, -or type mapping '<value>' is not valid. -20000 - - -42613 -Multiple or conflicting keywords involving the '<clause>' -clause are present. -20000 - - -42621 -A check constraint or generated column that is defined -with '<value>' is invalid. -20000 - - -42622 -The name '<name>' is too long. The maximum -length is '<maximumLength>'. -20000 - - -42734 -Name '<name>' specified in context '<context>' -is not unique. -20000 - - -42802 -The number of values assigned is not the same as the -number of specified or implied columns. -20000 - - -42803 -An expression containing the column '<columnName>' -appears in the SELECT list and is not part of a GROUP BY clause. -20000 - - -42815 -The replacement value for '<value>' is invalid. -20000 - - -42815 -The data type, length or value of arguments '<firstArguement>' -and '<secondArguement>' is incompatible. -20000 - - -42818 -Comparisons between '<value>' and '<value>' -are not supported. -20000 - - -42820 -The floating point literal '<string>' contains -more than 30 characters. -20000 - - -42821 -Columns of type '<type>' cannot hold values -of type '<type>'. -20000 - - -42824 -An operand of LIKE is not a string, or the first operand -is not a column. -20000 - - -42831 -'<columnName>' cannot be a column of a primary -key or unique key because it can contain null values. -20000 - - -42834 -SET NULL cannot be specified because FOREIGN KEY '<key>' - cannot contain null values. -20000 - - -42837 -ALTER TABLE '<tableName>' specified attributes -for column '<columnName>' that are not compatible with the existing -column. -20000 - - -42846 -Cannot convert types '<type>' to '<type>'. -20000 - - -42877 -A qualified column name '<columnName>' is -not allowed in the ORDER BY clause. -20000 - - -42884 -No authorized routine named '<routineName>' -of type '<type>' having compatible arguments was found. -20000 - - -42886 -'<value>' parameter '<value>' requires -a parameter marker '<parameter>'. -20000 - - -42894 -DEFAULT value or IDENTITY attribute value is not valid -for column '<columnName>'. -20000 - - -428C1 -Only one identity column is allowed in a table. -20000 - - -428EK -The qualifier for a declared global temporary table -name must be SESSION. -20000 - - -42903 -Invalid use of an aggregate function. -20000 - - -42908 -The CREATE VIEW statement does not include a column -list. -20000 - - -42915 -Foreign Key '<key>' is invalid because '<value>'. -20000 - - -42916 -Synonym '<synonym2>' cannot be created for -'<synonym1>' as it would result in a circular synonym chain. -20000 - - -42939 -An object cannot be created with the schema name '<schemaName>'. - -20000 - - -42962 -Long column type column or parameter '<columnName>' -not permitted in declared global temporary tables or procedure definitions. - -20000 - - -42972 -An ON clause associated with a JOIN operator is not -valid. -20000 - - -42995 -The requested function does not apply to global temporary -tables. -20000 - - -42X01 -Syntax error: <error>. -20000 - - -42X02 -<value>. -20000 - - -42X03 -Column name '<columnName>' is in more than -one table in the FROM list. -20000 - - -42X04 -Column '<columnName>' 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 -'<columnName>' is not a column in the target table. -20000 - - -42X05 -Table '<tableName>' does not exist. -20000 - - -42X06 -Too many result columns specified for table '<tableName>'. - -20000 - - -42X07 -Null is only allowed in a VALUES clause within an INSERT -statement. -20000 - - -42X08 -The constructor for class '<className>' cannot -be used as an external virtual table because the class does not implement -'<constructorName>'. -20000 - - -42X09 -The table or alias name '<tableName>' is used -more than once in the FROM list. -20000 - - -42X10 - '<tableName>' is not an exposed table name -in the scope in which it appears. -20000 - - -42X12 -Column name '<tableName>' appears more than -once in the CREATE TABLE statement. -20000 - - -42X13 -Column name '<columnName>' appears more than -once in the column list of an INSERT statement. -20000 - - -42X14 -'<columnName>' is not a column in table or -VTI '<value>'. -20000 - - -42X15 -Column name '<columnName>' appears in a statement -without a FROM list. -20000 - - -42X16 -Column name '<columnName>' appears multiple -times in the SET clause of an UPDATE statement. -20000 - - -42X17 -In the Properties list of a FROM clause, the value '<value>' -is not valid as a joinOrder specification. Only the values FIXED and UNFIXED -are valid. -20000 - - -42X19 -The WHERE or HAVING clause or CHECK CONSTRAINT definition -is a '<value>' expression. It must be a BOOLEAN expression. -20000 - - -42X23 -Cursor <cursorName> is not updatable. -20000 - - -42X25 -The '<functionName>' function is not allowed -on the '<type>' type. -20000 - - -42X26 -The class '<className> for column '<columnName>' -does not exist or is inaccessible. This can happen if the class is not public. - -20000 - - -42X28 -Delete table '<tableName>' is not target of -cursor '<cursorName>'. -20000 - - -42X29 -Update table '<tableName>' is not the target -of cursor '<cursorName>'. -20000 - - -42X30 -Cursor '<cursorName>' not found. Verify that -autocommit is OFF. -20000 - - -42X31 -Column '<columnName>' is not in the FOR UPDATE -list of cursor '<cursorName>'. -20000 - - -42X32 -The number of columns in the derived column list must -match the number of columns in table '<tableName>'. -20000 - - -42X33 -The derived column list contains a duplicate column -name '<columnName>'. -20000 - - -42X34 -There is a ? parameter in the select list. This is -not allowed. -20000 - - -42X35 -It is not allowed for both operands of '<value>' -to be ? parameters. -20000 - - -42X36 -The '<operator>' operator is not allowed to -take a ? parameter as an operand. -20000 - - -42X37 -The unary '<operator>' operator is not allowed -on the '<type>' type. -20000 - - -42X38 -'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries. - -20000 - - -42X39 -Subquery is only allowed to return a single column. -20000 - - -42X40 -A NOT statement has an operand that is not boolean . -The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN. -20000 - - -42X41 -In the Properties clause of a FROM list, the property -'<propertyName>' is not valid (the property was being set to '<value>'). -20000 - - -42X42 -Correlation name not allowed for column '<columnName>' -because it is part of the FOR UPDATE list. -20000 - - -42X43 -The ResultSetMetaData returned for the class/object -'<className>' was null. In order to use this class as an external -virtual table, the ResultSetMetaData cannot be null. -20000 - - -42X44 -Invalid length '<length>' in column specification. - -20000 - - -42X45 -<type> is an invalid type for argument number <value> -of <value>. -20000 - - -42X48 -Value '<value>' is not a valid precision for <value>. -20000 - - -42X49 -Value '<value>' is not a valid integer literal. -20000 - - -42X50 -No method was found that matched the method call <methodName>.<value>(<value>), -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. -20000 - - -42X51 -The class '<className>' does not exist or -is inaccessible. This can happen if the class is not public. -20000 - - -42X52 -Calling method ('<methodName>') using a receiver -of the Java primitive type '<type>" is not allowed. -20000 - - -42X53 -The LIKE predicate can only have 'CHAR' or 'VARCHAR' -operands. Type '<type>' is not permitted. -20000 - - -42X54 -The Java method '<methodName>' has a ? as -a receiver. This is not allowed. -20000 - - -42X55 -Table name '<tableName>' should be the same -as '<value>'. -20000 - - -42X56 -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 '<value>'. -20000 - - -42X57 -The getColumnCount() for external virtual table '<tableName>' -returned an invalid value '<value>'. Valid values are greater than -or equal to 1. -20000 - - -42X58 -The number of columns on the left and right sides of -the <tableName> must be the same. -20000 - - -42X59 -The number of columns in each VALUES constructor must -be the same. -20000 - - -42X60 -Invalid value '<value>' for insertMode property -specified for table '<tableName>'. -20000 - - -42X61 -Types '<type>' and '<type>' are -not <value> compatible. -20000 - - -42X62 -'<value>' is not allowed in the '<schemaName>' -schema. -20000 - - -42X63 -The USING clause did not return any results. No parameters -can be set. -20000 - - -42X64 -In the Properties list, the invalid value '<value>' -was specified for the useStatistics property. The only valid values are TRUE -or FALSE . -20000 - - -42X65 -Index '<index>' does not exist. -20000 - - -42X66 -Column name '<columnName>' appears more than -once in the CREATE INDEX statement. -20000 - - -42X68 -No field '<fieldName>' was found belonging -to class '<className>'. The field might exist, but it is not public, -or the class does not exist or is not public. -20000 - - -42X69 -It is not allowed to reference a field ('<fieldName>') -using a referencing expression of the Java primitive type '<type>'. -20000 - - -42X72 -No static field '<fieldName>' was found belonging -to class '<className>'. The field might exist, but it is not public -and/or static, or the class does not exist or the class is not public. -20000 - - -42X73 -Method resolution for signature <value>.<value>(<value>) -was ambiguous. (No single maximally specific method.) -20000 - - -42X74 -Invalid CALL statement syntax. -20000 - - -42X75 -No constructor was found with the signature <value>(<value>). - It may be that the parameter types are not method invocation convertible. -20000 - - -42X76 -At least one column, '<columnName>', in the -primary key being added is nullable. All columns in a primary key must be -non-nullable. -20000 - - -42X77 -Column position '<columnPosition>' is out -of range for the query expression. -20000 - - -42X78 -Column '<columnName>' is not in the result -of the query expression. -20000 - - -42X79 -Column name '<columnName>' appears more than -once in the result of the query expression. -20000 - - -42X80 -VALUES clause must contain at least one element. Empty -elements are not allowed. -20000 - - -42X82 -The USING clause returned more than one row. Only single-row -ResultSets are permissible. -20000 - - -42X83 -The constraints on column '<columnName>' require -that it be both nullable and not nullable. -20000 - - -42X84 -Index '<index>' was created to enforce constraint -'<constraintName>'. It can only be dropped by dropping the constraint. -20000 - - -42X85 -Constraint '<constraintName>' is required -to be in the same schema as table '<tableName>'. -20000 - - -42X86 -ALTER TABLE failed. There is no constraint '<constraintName>' -on table '<tableName>'. -20000 - - -42X87 -At least one result expression (THEN or ELSE) of the -'<expression>' expression must not be a '?'. -20000 - - -42X88 -A conditional has a non-boolean operand. The operand -of a conditional must evaluate to TRUE, FALSE, or UNKNOWN. -20000 - - -42X89 -Types '<type>' and '<type>' are -not type compatible. Neither type is assignable to the other type. -20000 - - -42X90 -More than one primary key constraint specified for table -'<tableName>'. -20000 - - -42X91 -Constraint name '<constraintName>' appears -more than once in the CREATE TABLE statement. -20000 - - -42X92 -Column name '<columnName>' appears more than -once in a constraint's column list. -20000 - - -42X93 -Table '<tableName>' contains a constraint -definition with column '<columnName>' which is not in the table. -20000 - - -42X94 -<value> '<value>' does not exist. -20000 - - -42X96 -The database class path contains an unknown jar file -'<fileName>'. -20000 - - -42X98 -Parameters are not allowed in a VIEW definition. -20000 - - -42Y00 -Class '<className>' does not implement org.apache.derby.iapi.db.AggregateDefinition -and thus cannot be used as an aggregate expression. -20000 - - -42Y01 -Constraint '<constraintName>' is invalid. - -20000 - - -42Y03 -'<statement>' is not recognized as a function -or procedure. -20000 - - -42Y04 -Cannot create a procedure or function with EXTERNAL -NAME '<name>' because it is not a list separated by periods. The -expected format is <fulljavapath>.<method name>. -20000 - - -42Y05 -There is no Foreign Key named '<key>'. -20000 - - -42Y07 -Schema '<schemaName>' does not exist. -20000 - - -42Y08 -Foreign key constraints are not allowed on system tables. -20000 - - -42Y09 -Void methods are only allowed within a CALL statement. -20000 - - - 42Y10 -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. -20000 - - -42Y11 -A join specification is required with the '<clauseName>' -clause. -20000 - - -42Y12 -The ON clause of a JOIN is a '<expressionType>' -expression. It must be a BOOLEAN expression. -20000 - - -42Y13 -Column name '<columnName>' appears more than -once in the CREATE VIEW statement. -20000 - - -42Y16 -No public static method '<methodName>' was -found in class '<className>'. The method might exist, but it is -not public, or it is not static. -20000 - - -42Y19 -'<columnName>' appears multiple times in the -GROUP BY list. Columns in the GROUP BY list must be unambiguous. -20000 - - -42Y22 -Aggregate <aggregateType> cannot operate on -type <type>. -20000 - - -42Y23 -Incorrect JDBC type info returned for column <columnName>. - -20000 - - -42Y24 -View '<viewName>' is not updatable. (Views -are currently not updatable.) -20000 - - -42Y25 -'<tableName>' is a system table. Users are -not allowed to modify the contents of this table. -20000 - - -42Y27 -Parameters are not allowed in the trigger action. -20000 - - -42Y29 -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. -20000 - - -42Y30 -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. -20000 - - -42Y32 -Aggregator class '<className> aggregate '<aggregateName>' -on type <type> does not implement com.ibm.db2j.aggregates.Aggregator. - -20000 - - -42Y33 -Aggregate <aggregateName> contains one or -more aggregates. -20000 - - -42Y34 -Column name '<columnName>' matches more than -one result column in table '<tableName>'. -20000 - - -42Y35 -Column reference '<reference>' is invalid. -When the SELECT list contains at least one aggregate then all entries must -be valid aggregate expressions. -20000 - - -42Y36 -Column reference '<value>' is invalid. For -a SELECT list with a GROUP BY, the list may only contain grouping columns -and valid aggregate expressions. -20000 - - -42Y37 -'<value>' is a Java primitive and cannot be -used with this operator. -20000 - - -42Y38 -insertMode = replace is not permitted -on an insert where the target table, '<tableName>', is referenced -in the SELECT. -20000 - - -42Y39 -'<value>' may not appear in a CHECK CONSTRAINT -definition because it may return non-deterministic results. -20000 - - -42Y40 -'<value>' appears multiple times in the UPDATE -OF column list for trigger '<triggerName>'. -20000 - - -42Y41 -'<value>' cannot be directly invoked via EXECUTE -STATEMENT because it is part of a trigger. -20000 - - -42Y42 -Scale '<scaleValue>' is not a valid scale -for a <value>. -20000 - - -42Y43 -Scale '<scaleValue>' is not a valid scale -with precision of '<precision>'. -20000 - - -42Y44 -Invalid key '<key>' specified in the Properties -list of a FROM list. The case-sensitive keys that are currently supported -are '<key>'. -20000 - - -42Y45 -VTI '<value>' cannot be bound because it is -a special trigger VTI and this statement is not part of a trigger action or -WHEN clause. -20000 - - -42Y46 -Invalid Properties list in FROM list. There is no index -'<index>' on table '<tableName>'. -20000 - - -42Y48 -Invalid Properties list in FROM list. Either there -is no named constraint '<constraintName>' on table '<tableName>' -or the constraint does not have a backing index. -20000 - - -42Y49 -Multiple values specified for property key '<key>'. - -20000 - - -42Y50 -Properties list for table '<tableName>' may -contain values for index or for constraint but not both. -20000 - - -42Y55 -'<value>' cannot be performed on '<value>' -because it does not exist. -20000 - - -42Y56 -Invalid join strategy '<strategyValue>' specified -in Properties list on table '<tableName>'. The currently supported -values for a join strategy are: hash and nestedloop. -20000 - - -42Y58 -NumberFormatException occurred when converting value -'<value>' for optimizer override '<value>'. -20000 - - -42Y59 -Invalid value, '<value>', specified for hashInitialCapacity -override. Value must be greater than 0. -20000 - - -42Y60 -Invalid value, '<value>', specified for hashLoadFactor -override. Value must be greater than 0.0 and less than or equal to 1.0. -20000 - - -42Y61 -Invalid value, '<value>' specified for hashMaxCapacity -override. Value must be greater than 0. -20000 - - -42Y62 -'<value>' is not allowed on '<value>' -because it is a view. -20000 - - -42Y63 -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 '<index>'. Use the -'index' optimizer override to specify such an index or the heap on table '<tableName>'. -20000 - - -42Y64 -bulkFetch value of '<value>' is invalid. The -minimum value for bulkFetch is 1. -20000 - - -42Y65 -bulkFetch is not permitted on '<joinType>' -joins. -20000 - - -42Y66 -bulkFetch is not permitted on updatable cursors. -20000 - - -42Y67 -Schema '<schemaName>' cannot be dropped. -20000 - - -42Y69 -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. -20000 - - - 42Y70 -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. -20000 - - -42Y71 -System function or procedure '<procedureName>' -cannot be dropped. -20000 - - -42Y82 -System generated stored prepared statement '<statement>' -that cannot be dropped using DROP STATEMENT. It is part of a trigger. -20000 - - - 42Y83 -An untyped null is not permitted as an argument to aggregate <aggregateName>. - Please cast the null to a suitable type. -20000 - - -42Y84 -'<value>' may not appear in a DEFAULT definition. - -20000 - - -42Y85 -The DEFAULT keyword is only allowed in a VALUES clause -when the VALUES clause appears within an INSERT statement. -20000 - - -42Y90 -FOR UPDATE is not permitted in this type of statement. - -20000 - - -42Y91 -The USING clause is not permitted in an EXECUTE STATEMENT -for a trigger action. -20000 - - -42Y92 -<triggerName> triggers may only reference <value> -transition variables/tables. -20000 - - -42Y93 -Illegal REFERENCING clause: only one name is permitted -for each type of transition variable/table. -20000 - - -42Y94 -An AND or OR has a non-boolean operand. The operands -of AND and OR must evaluate to TRUE, FALSE, or UNKNOWN. -20000 - - -42Y95 -The '<operatorName>' operator with a left -operand type of '<operandType>' and a right operand type of '<operandType>' -is not supported. -20000 - - -42Y97 -Invalid escape character at line '<lineNumber>', -column '<columnName>'. -20000 - - -42Z02 -Multiple DISTINCT aggregates are not supported at this -time. -20000 - - -42Z07 -Aggregates are not permitted in the ON clause. -20000 - - -42Z08 -Bulk insert replace is not permitted on '<value>' -because it has an enabled trigger (<value>). -20000 - - -42Z15 -Invalid type specified for column '<columnName>'. -The type of a column may not be changed. -20000 - - -42Z16 -Only columns of type VARCHAR may have their length altered. -20000 - - -42Z17 -Invalid length specified for column '<columnName>'. -Length must be greater than the current column length. -20000 - - -42Z18 -Column '<columnName>' is part of a foreign -key constraint '<constraintName>'. To alter the length of this column, -you should drop the constraint first, perform the ALTER TABLE, and then recreate -the constraint. -20000 - - -42Z19 -Column '<columnName>' is being referenced -by at least one foreign key constraint '<constraintName>'. To alter -the length of this column, you should drop referencing constraints, perform -the ALTER TABLE, and then recreate the constraints. -20000 - - -42Z20 -Column '<columnName>' cannot be made nullable. -It is part of a primary key, which cannot have any nullable columns. -20000 - - -42Z21 -Invalid increment specified for identity for column -'<columnName>'. Increment cannot be zero. -20000 - - -42Z22 -Invalid type specified for identity column '<columnName>'. -The only valid types for identity columns are BIGINT, INT and SMALLINT. -20000 - - -42Z23 -Attempt to modify an identity column '<columnName>'. -20000 - - -42Z24 -Overflow occurred in identity value for column '<columnName>' -in table '<tableName>'. -20000 - - - 42Z25 -INTERNAL ERROR identity counter. Update was called without - arguments with current value = NULL. -20000 - - -42Z26 -A column, '<columnName>', with an identity -default cannot be made nullable. -20000 - - -42Z27 -A nullable column, '<columnName>', cannot -be modified to have identity default. -20000 - - -42Z50 -INTERNAL ERROR: Unable to generate code for <value>. -20000 - - -42Z53 -INTERNAL ERROR: Do not know what type of activation -to generate for node choice <value>. -20000 - - -42Z90 -Class '<className>' does not return an updatable -ResultSet. -20000 - - -42Z91 -subquery -20000 - - -42Z92 -repeatable read -20000 - - -42Z93 -Constraints '<constraintName>' and '<constraintName>' -have the same set of columns, which is not allowed. -20000 - - -42Z97 -Renaming column '<columnName>' will cause -check constraint '<constraintName>' to break. -20000 - - -42Z99 -String or Hex literal cannot exceed 64K. -20000 - - -42Z9A -read uncommitted -20000 - - -42Z9B -The external virtual table interface does not support -BLOB or CLOB columns. '<value>' column '<value>'. -20000 - - -42Z9D -'<statement>' statements are not allowed in -'<triggerName>' triggers. -20000 - - -42Z9E -Constraint '<constraintName>' is not a <value> -constraint. -20000 - - -42Z9F -Too many indexes (<index>) on the table <tableName>. -The limit is <number>. -20000 - - - -

Class Code XOX: Execution exceptions - - - -SQLState -Message Text -Severity - - - - -X0X02 -Table '<tableName>' cannot be locked in '<mode>' -mode. -20000 - - -X0X03 -Invalid transaction state - held cursor requires same -isolation level -20000 - - -X0X05 -Table '<tableName>' does not exist. -20000 - - -X0X07 -Cannot drop jar file '<fileName>' because -its on your db2j.database.classpath '<classpath>'. -20000 - - -X0X0E -The column position '<columnPosition>' listed -in the auto-generated column selection array was not found in the insert table. -20000 - - -X0X0F -Column name '<columnName>' listed in auto-generated -column selection array not found in the insert table. -20000 - - -X0X10 -The USING clause returned more than one row; only single-row -ResultSets are permissible. -20000 - - -X0X11 -The USING clause did not return any results so no parameters -can be set. -20000 - - -X0X13 -Jar file '<fileName>' does not exist in schema -'<schemaName>'. -20000 - - -X0X14 -Binding directly to an XML value is not allowed; try -using XMLPARSE. -20000 - - -X0X15 -XML values are not allowed in top-level result sets; -try using XMLSERIALIZE. -20000 - - -X0X16 -XML syntax error; missing keyword(s): '<keywords>'. -20000 - - -X0X17 -Invalid target type for XMLSERIALIZE: '<value>'. -20000 - - -X0X18 -XML feature not supported: '<featureName>'. -20000 - - -X0X57 -An attempt was made to put a Java value of type '<type>' -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. -20000 - - -X0X60 -A cursor with name '<cursorName>' already -exists. -20000 - - -X0X61 -The values for column '<value>' in index '<value>' -and table '<value>.<value>' do not match for row location <value>. - The value in the index is '<value>', while the value in the base -table is '<value>'. The full index key, including the row location, -is '<value>'. The suggested corrective action is to recreate the -index. -20000 - - -X0X62 -Inconsistency found between table '<tableName>' -and index '<index>'. Error when trying to retrieve row location -'<rowLocation>' from the table. The full index key, including the -row location, is '<index>'. The suggested corrective action is to -recreate the index. -20000 - - -X0X63 -Got IOException '<value>'. -20000 - - -X0X67 -Columns of type '<type>' 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. -20000 - - -X0X81 -<value> '<value>' does not exist. - -20000 - - -X0X85 -Index '<index>' was not created because '<type>' -is not a valid index type. -20000 - - -X0X86 -0 is an invalid parameter value for ResultSet.absolute(int row). - -20000 - - -X0X87 -ResultSet.relative(int row) cannot -be called when the cursor is not positioned on a row. -20000 - - -X0X95 -Operation '<operation>' cannot be performed -on object '<object>' because there is an open ResultSet dependent -on that object. -20000 - - -X0X99 -Index '<index>' does not exist. -20000 - - -X0XML -Encountered unexpected error while processing XML; see -next exception for details. -20000 - - - -

Class Code X0Y: Execution exceptions - - - -SQLSTATE -Message Text -Severity - - - - -X0Y16 -'<value>' is not a view. If it is a table, -then use DROP TABLE instead. -20000 - - -X0Y23 -Operation '<operation>' cannot be performed -on object '<object>' because VIEW '<viewName>' is dependent -on that object. -20000 - - -X0Y24 -Operation '<operation>' cannot be performed -on object '<object>' because STATEMENT '<statement>' is -dependent on that object. -20000 - - -X0Y25 -Operation '<value>' cannot be performed on -object '<value>' because <value> '<value>' is -dependent on that object. -20000 - - -X0Y26 -Index '<index>' is required to be in the same -schema as table '<tableName>'. -20000 - - -X0Y28 -Index '<index>' cannot be created on system -table '<tableName>'. Users cannot create indexes on system tables. -20000 - - -X0Y32 -<value> '<value>' already exists -in <value> '<value>'. -20000 - - -X0Y38 -Cannot create index '<index>' because table -'<tableName>' does not exist. -20000 - - -X0Y41 -Constraint '<constraintName>' is invalid because -the referenced table <tableName> has no primary key. Either add -a primary key to <tableName> or explicitly specify the columns of -a unique constraint that this foreign key references. -20000 - - -X0Y42 -Constraint '<constraintName>' is invalid: -the types of the foreign key columns do not match the types of the referenced -columns -20000 - - -X0Y43 -Constraint '<value>' is invalid: the number -of columns in <value> (<value>) does not match the number -of columns in the referenced key (<value>). -20000 - - -X0Y44 -Constraint '<constraintName>' is invalid: -there is no unique or primary key constraint on table '<tableName>' -that matches the number and types of the columns in the foreign key. - -20000 - - -X0Y45 -Foreign key constraint '<constraintName>' -cannot be added to or enabled on table <tableName> because one or -more foreign keys do not have matching referenced keys. -20000 - - -X0Y46 -Constraint '<constraintName>' is invalid: -referenced table <tableName> does not exist. -20000 - - -X0Y54 -Schema '<schemaName>' cannot be dropped because -it is not empty. -20000 - - -X0Y55 -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 '<value>' -on table '<value>.<value>' has <value> rows, -but the base table has <value> rows. The suggested corrective action -is to recreate the index. -20000 - - -X0Y56 -'<value>' is not allowed on the System table -'<value>'. -20000 - - -X0Y57 -A non-nullable column cannot be added to table '<tableName>' -because the table contains at least one row. Non-nullable columns can only -be added to empty tables. -20000 - - -X0Y58 -Attempt to add a primary key constraint to table '<tableName>' -failed because the table already has a constraint of that type. A table can -only have a single primary key constraint. -20000 - - -X0Y59 -Attempt to add or enable constraint(s) on table '<tableName>' -failed because the table contains <rowName> row(s) that violate -the following check constraint(s): <constraintName>. -20000 - - -X0Y63 -The command on table '<tableName>' 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. - -20000 - - -X0Y66 -Cannot issue commit in a nested connection when there -is a pending operation in the parent connection. -20000 - - -X0Y67 -Cannot issue rollback in a nested connection when there -is a pending operation in the parent connection. -20000 - - -X0Y68 -<value> '<value>' already exists. - -20000 - - -X0Y69 -<value> is not permitted because trigger <triggerName> -is active on <value>. -20000 - - -X0Y70 -INSERT, UPDATE and DELETE are not permitted on table <tableName> -because trigger <triggerName> is active. -20000 - - -X0Y71 -Transaction manipulation such as SET ISOLATION is not -permitted because trigger <triggerName> is active. -20000 - - -X0Y72 -Bulk insert replace is not permitted on '<value>' -because it has an enabled trigger (<value>). -20000 - - -X0Y77 -Cannot issue set transaction isolation statement on -a global transaction that is in progress because it would have implicitly -committed the global transaction. -20000 - - -X0Y78 -Statement.executeQuery() cannot be called with a statement -that returns a row count. -20000 - - -X0Y79 -Statement.executeUpdate() cannot be called with a statement -that returns a ResultSet. -20000 - - -X0Y80 -ALTER table '<tableName>' failed. Null data -found in column '<columnName>'. -20000 - - -X0Y83 - -WARNING: While deleting a row from a table the index -row for base table row <rowName> was not found in index with conglomerate -id <id>. This problem has automatically been corrected as part -of the delete operation. -20000 - - - -

Class Code XBCA: CacheService - - - -SQLSTATE -Message Text -Severity - - - - -XBCA0 -Cannot create new object with key <key> in <cache> -cache. The object already exists in the cache. -20000 - - - -

Class Code XBCM: ClassManager - - - [... 2186 lines stripped ...]