Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| 52W18 | Error | 2098 | -613L | "User-defined type '%1' not found" | The user-defined type with this name does not exist in the database. Click here for a list of possible parameters and odbc states. |
| 52W19 | Error | 2468 | -821L | "Dbspace for table '%1' not found" | You tried to access a table in a dbspace that the database server could not find. You may need to change the file name associated with the dbspace using the ALTER DBSPACE statement. Click here for a list of possible parameters and odbc states. |
| 52W20 | Error | 2219 | -616L | "Too many columns in table" | You executed a CREATE TABLE or ALTER TABLE statement that attempted to add a column to a table. The resulting number of columns in the table would exceed the limit for the current database page size. Click here for a list of possible parameters and odbc states. |
| 52W21 | Error | 2226 | -623L | "Data definition statements not allowed in procedures or triggers" | The procedure or trigger definition contains a data definition statement (such as CREATE, DROP, GRANT, REVOKE, or ALTER). These statements are not allowed within procedures or triggers. Click here for a list of possible parameters and odbc states. |
| 52W22 | Error | 2240 | -635L | "GRANT of column permission on view not allowed" | You cannot grant permissions on columns for views. Click here for a list of possible parameters and odbc states. |
| 52W23 | Error | 2307 | -680L | "Invalid expression in WHERE clause of Transact-SQL outer join" | An expression in the WHERE clause of a query that uses Transact-SQL syntax contains a comparison of a column from the NULL-supplying table with a subquery or an expression that references a column from another table. Click here for a list of possible parameters and odbc states. |
| 52W24 | Error | 2308 | -681L | "Invalid join type used with Transact-SQL outer join" | An invalid join type was used with a query that contains Transact-SQL outer join comparison operators. Click here for a list of possible parameters and odbc states. |
| 52W25 | Error | 2338 | -710L | "Invalid comparison" | An attempt was made to compare two arguments that do not support comparison. For example, it is not valid to compare a Java object with another Java object, unless the class of the object supports a valid compareTo method. Click here for a list of possible parameters and odbc states. |
| 52W26 | Error | 2758 | -1089L | "Invalid commit action for shared temporary table" | A global shared temporary table must be declared as ON COMMIT PRESERVE ROWS or NOT TRANSACTIONAL. Click here for a list of possible parameters and odbc states. |
| 52W40 | Error | 2305 | -678L | "Index name '%1' is ambiguous" | A statement has referred to an index name that is not unique. Preface the index name with the table and/or owner name. Click here for a list of possible parameters and odbc states. |
| 52W41 | Error | 2464 | -817L | "Too many temporary tables in connection" | A CREATE TABLE or DECLARE TABLE statement attempted to create a temporary table, but the resulting number of distinct table ids used for temporary tables in the current connection would exceed the limit. Click here for a list of possible parameters and odbc states. |
| 52W42 | Error | 2499 | -852L | "Table name '%1' is ambiguous" | A statement has referred to a table name that is not unique. Preface the table name by an owner name. Click here for a list of possible parameters and odbc states. |
| 52W43 | Error | 2737 | -1068L | "Default dbspace '%1' not found" | You tried to create a table with the default_dbspace option set to a dbspace that could not be found. Click here for a list of possible parameters and odbc states. |
| 53002 | Error | 2133 | -207L | "Wrong number of values for INSERT" | The number of values you are trying to insert does not match the number of columns specified in the INSERT statement, or the number of columns in the table if no columns are specified. Click here for a list of possible parameters and odbc states. |
| 53003 | Error | 2092 | -149L | "Function or column reference to '%1' must also appear in a GROUP BY" | You used a non-aggregate function or column reference in the select list or in a nested query block that does not appear in the GROUP BY clause. In a query using GROUP BY, select list items that are not aggregate functions must also appear in the GROUP BY clause. If the select list item is a column reference or an alias, you may add the column name or alias to the GROUP BY clause. If the select list item is a scalar function, ensure that the function's arguments in the GROUP BY clause match exactly with those in the select list. In some cases, you may want to use the MAX function on the column name (or another aggregate function) instead of adding the column to the GROUP BY clause. Click here for a list of possible parameters and odbc states. |
| 53005 | Error | 2095 | -152L | "Invalid ORDER BY specification" | Either you used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list, or you specified an ORDER BY expression that is semantically invalid. For example, with UNION queries you can only use integers to specify an ordering of the result. Click here for a list of possible parameters and odbc states. |
| 53011 | Error | 2051 | -114L | "Number of columns defined for the view does not match SELECT statement" | You attempted to create a view, but the column list specified as part of the CREATE VIEW statement does not correspond to the list of items in the view's SELECT statement. Click here for a list of possible parameters and odbc states. |
| 53017 | Error | 2533 | -162L | "Cannot convert %1 to a %2. The bad value was supplied for column '%3' on row %4 of the data file" | The data file supplied to LOAD TABLE contains a value that cannot be converted to the required data type. Click here for a list of possible parameters and odbc states. |
| 53018 | Error | 2104 | -157L | "Cannot convert %1 to a %2" | An error occurred while trying to convert a value to another data type. Click here for a list of possible parameters and odbc states. |
| 53019 | Error | 2333 | -705L | "Return type of void from procedure '%1' cannot be used in any expression" | The Java type void does not map onto any SQL type, hence a procedure returning void cannot be used in any SQL expression. Click here for a list of possible parameters and odbc states. |