Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1041L | Error | 2710 | 42WB5 | "Materialized View '%1' not found" | You misspelled the name of a materialized view, or you did not qualify a materialized view name with a user name. For example, you might have referred to "Employees" instead of "DBA"."Employees". Click here for a list of possible parameters and odbc states. |
| -1042L | Error | 2711 | WW065 | "Cannot add a comment to a table declared as LOCAL TEMPORARY" | You attempted to add a comment to a table that has been declared as LOCAL TEMPORARY. This is not allowed. Click here for a list of possible parameters and odbc states. |
| -1043L | Error | 2712 | 57W01 | "Request interrupted due to timeout" | The current request was canceled during its execution since it ran for longer than the request_timeout database option value. The database was able to stop the operation without doing a rollback. If the statement is INSERT, UPDATE, or DELETE, any changes made by the statement will be canceled. If the statement is a data definition statement (for example CREATE TABLE), the statement will be canceled, but the COMMIT that was done as a side effect will not be canceled. Click here for a list of possible parameters and odbc states. |
| -1044L | Error | 2713 | 28W11 | "Invalid password: %1" | The attempt to create a new user ID or change a password failed. The function specified by the verify_password_function option disallowed the password. Click here for a list of possible parameters and odbc states. |
| -1045L | Error | 2714 | WB015 | "Invalid backup parameter value" | One or more of the parameters supplied to the backup operation has an invalid value. Click here for a list of possible parameters and odbc states. |
| -1046L | Error | 2715 | 55W19 | "Illegal column definition: %1" | You are attempting to define a column in a way that is not allowed. Click here for a list of possible parameters and odbc states. |
| -1047L | Error | 2716 | 55W20 | "This database does not support encrypted tables" | You tried to create an encrypted table in a database that does not support them. Click here for a list of possible parameters and odbc states. |
| -1050L | Error | 2719 | 22030 | "Cannot return NULL result as requested data type" | You tried to retrieve a value from the database that was NULL and assign it to a variable that cannot be NULL. Click here for a list of possible parameters and odbc states. |
| -1051L | Error | 2720 | 42WB6 | "Cannot create a materialized view because option '%1' has an inappropriate setting" | You attempted to create a materialized view, but one of the database options is currently set to a value not permitted while creating a materialized view. Click here for a list of possible parameters and odbc states. |
| -1052L | Error | 2721 | 42WB7 | "Cannot update materialized view because option '%1' has an inappropriate setting" | You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option's setting does not match the value when the view was created. Click here for a list of possible parameters and odbc states. |
| -1053L | Error | 2722 | 42W85 | "'%1' is an invalid value for '%2'" | You supplied an invalid value for an option. Some options only allow numeric values and some options only allow true or false. Also, many options do not permit the empty string as a value. Click here for a list of possible parameters and odbc states. |
| -1054L | Error | 2723 | 55W23 | "Snapshot isolation disabled or pending" | Snapshot isolation is disabled or its activation is still pending. You must enable snapshot isolation before using it. Click here for a list of possible parameters and odbc states. |
| -1057L | Error | 2726 | WB016 | "BACKUP clause '%1' conflicts with '%2'" | Clauses specified in the BACKUP STATEMENT are mutually exclusive. Click here for a list of possible parameters and odbc states. |
| -1060L | Error | 2729 | 5RW38 | "Operation conflict with publication type" | You attempted to perform an operation not applicable to the type of publication. For example, you applied operations specific to a scripted upload publication to a logscan publication. Click here for a list of possible parameters and odbc states. |
| -1061L | Error | 2730 | 42WB8 | "Table created or altered after start of snapshot" | A snapshot transaction attempted to use a table that was created or altered after the transaction began. Click here for a list of possible parameters and odbc states. |
| -1062L | Error | 2731 | 42WB9 | "Statement not allowed during snapshot" | A connection with an outstanding snapshot attempted to use CREATE INDEX, DROP INDEX, ALTER INDEX or ALTER TABLE. Make sure all cursors for the connection are closed. Click here for a list of possible parameters and odbc states. |
| -1063L | Error | 2732 | 08W93 | "Unable to start database %1: Cannot use read-only mode if auditing is enabled" | The specified database has auditing enabled, and cannot be started read-only. Click here for a list of possible parameters and odbc states. |
| -1064L | Error | 2733 | 42WBA | "Update conflict on snapshot transaction" | A snapshot transaction attempted to update or delete a row that was changed by another transaction after the snapshot began. Click here for a list of possible parameters and odbc states. |
| -1065L | Error | 2734 | 42WBB | "Attempt to use snapshot isolation in a non-snapshot transaction" | A transaction tried to use snapshot isolation but did not begin with snapshot isolation. Click here for a list of possible parameters and odbc states. |
| -1066L | Error | 2735 | WO027 | "File system error: %1" | This error results from an error in the underlying file system that was encountered while accessing a file directory as a proxy table. Click here for a list of possible parameters and odbc states. |