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 |
|---|---|---|---|---|---|
| 42WC8 | Error | 2897 | -1219L | "Maintenance of dependent immediate materialized view(s) failed" | Maintenance of immediate materialized view(s) dependent on the base table failed. Click here for a list of possible parameters and odbc states. |
| 42WC9 | Error | 2911 | -1232L | "Attempt to start a second snapshot in a transaction" | A transaction tried to start a snapshot (for example, using the BEGIN SNAPSHOT statement) while another snapshot was already active. Click here for a list of possible parameters and odbc states. |
| 42WCA | Error | 2912 | -1233L | "The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns." | You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-nullable columns. Create a unique index on the materialized view before changing the refresh type. Click here for a list of possible parameters and odbc states. |
| 42WCB | Error | 2955 | -1268L | "The materialized view cannot be changed to immediate because its definition contains an illegal construct." | You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal construct. Click here for a list of possible parameters and odbc states. |
| 42WCC | Error | 2956 | -1269L | "Service statement definition is invalid or unsupported" | Either the statement provided is invalid or it is unsupported within the context of a service. Click here for a list of possible parameters and odbc states. |
| 42WCD | Error | 2974 | -1286L | "Immediate materialized view definition cannot contain a SUM function over a nullable expression." | You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression. Click here for a list of possible parameters and odbc states. |
| 42WCE | Error | 3009 | -1327L | "The materialized view cannot be changed to immediate because its SELECT list contains a SUM function over a nullable expression and it doesn't contain a COUNT function over the same expression" | You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression but it doesn't contain COUNT function over the same expression. Click here for a list of possible parameters and odbc states. |
| 42WD0 | Error | 2939 | -1256L | "Event of %1 type already exists" | An attempt was made to define a new event of the type that already exists. Click here for a list of possible parameters and odbc states. |
| 42WD1 | Error | 2940 | -1257L | "Multiple event conditions cannot be specified with this event type" | An attempt was made to specify more than one condition for an event type. Click here for a list of possible parameters and odbc states. |
| 42WD2 | Error | 2941 | -1258L | "'<' or '<=' operator can only be used in the event condition with this event type" | Event of this type can be defined with a condition having < or <= operator only. Click here for a list of possible parameters and odbc states. |
| 42WD3 | Error | 2957 | -1270L | "Must own table '%1' to make an immediate view reference it" | You have attempted to change the refresh type of a materialized view to immediate and the view references a table that is not owned by you. To perform this operation, you must either own all the tables referenced by the materialized view or have DBA privileges. Click here for a list of possible parameters and odbc states. |
| 42WD4 | Error | 2978 | -1290L | "FOR UPDATE or FOR READ ONLY clause must be specified on PREPARE (not on DECLARE CURSOR)" | You specified the FOR UPDATE or FOR READ ONLY clause on a DECLARE CURSOR statement. The FOR UPDATE or FOR READ ONLY clause must be specified on the PREPARE statement and not the DECLARE CURSOR statement. Click here for a list of possible parameters and odbc states. |
| 42WE0 | Error | 2823 | -1330L | "The function '%1' does not allow use of the '%2' clause" | You have attempted to use the specified SQL clause within the context of a function that does not permit such use. Note that the function may have been used directly in the query or indirectly within a named window. Click here for a list of possible parameters and odbc states. |
| 42WE1 | Error | 2807 | -1331L | "The function '%1' requires the use of the '%2' clause" | You have attempted to invoke the specified function without the use of a mandatory SQL clause within the context of the function. Note that the function may have been used directly in the query or indirectly within a named window. Click here for a list of possible parameters and odbc states. |
| 42WE2 | Error | 3047 | -1367L | "User owns sequences in use" | You attempted to drop a user that owns a sequence being used by other active users of the database. Click here for a list of possible parameters and odbc states. |
| 42WE3 | Error | 3046 | -1366L | "Sequence '%1' in use by another connection" | You have attempted to drop a sequence that is currently being used by another connection. Click here for a list of possible parameters and odbc states. |
| 42WE4 | Error | 3051 | -1371L | "The materialized view cannot be changed to immediate because the ON conditions must refer to both sides of the OUTER JOIN." | You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal ON condition. Click here for a list of possible parameters and odbc states. |
| 42WE5 | Error | 2681 | -1398L | "VERIFY and RENAME cannot be used together" | Since VERIFY will never write to any dbspaces, renaming dbspaces cannot be done during restore verification. Click here for a list of possible parameters and odbc states. |
| 42WE6 | Error | 3172 | -1505L | "Mirror server \"%1\" defined with type COPY does not include a parent definition" | In a CREATE MIRROR SERVER statement for a server with type COPY, a parent server is not defined. Click here for a list of possible parameters and odbc states. |
| 42WE7 | Error | 3175 | -1507L | "The materialized view cannot be changed to immediate because the ON conditions refer to tables which are not in the null-supplying and preserved sides of the OUTER JOINs." | You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal ON condition. Click here for a list of possible parameters and odbc states. |