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 |
|---|---|---|---|---|---|
| -1196L | Error | 2873 | WW099 | "Login policies are not supported for this database" | The current database does not have catalog support for login policies. To use this feature, upgrade your database to the most recent version. Click here for a list of possible parameters and odbc states. |
| -1197L | Error | 2874 | WW100 | "Login policy \"%1\" in use" | The named login policy is associated with a user in the database. Any users associated with the login policy must be assigned a different login policy before the named login policy can be dropped. Click here for a list of possible parameters and odbc states. |
| -1198L | Error | 2875 | WW101 | "User \"%1\" already exists" | An attempt was made to create a user that already exists in the database. Click here for a list of possible parameters and odbc states. |
| -1199L | Error | 2876 | 42WC6 | "The materialized view cannot be changed to immediate because COUNT(*) must be part of the SELECT list." | You attempted to change the refresh type to immediate for a materialized view whose definition does not include COUNT(*) in the SELECT list. Click here for a list of possible parameters and odbc states. |
| -1200L | Error | 2877 | WW103 | "Client library reported a permissions error accessing object ('%1') during transfer" | The client application reported a permissions error while attempting to access the object for a data transfer request from the server. The client application likely does not have the necessary operating system authorization required to access the object. Click here for a list of possible parameters and odbc states. |
| -1201L | Error | 2878 | WW102 | "Client library reported an error opening object ('%1') during transfer" | The client application reported an error while attempting to open the object for a data transfer request from the server. Reasons could include an invalid name for the object or a missing object. Click here for a list of possible parameters and odbc states. |
| -1202L | Error | 2879 | 55W31 | "Operation not allowed on a table with dependent immediate materialized views" | Requested operation cannot be applied to a table with dependent immediate materialized views. Click here for a list of possible parameters and odbc states. |
| -1203L | Error | 2880 | 55W32 | "WRITETEXT not allowed: immediate materialized view %1 depends on %2" | WRITETEXT is not allowed on base tables that have dependent initialized immediate materialized views. No operation that does not fire triggers is allowed on base tables with dependent initialized immediate materialized views. Click here for a list of possible parameters and odbc states. |
| -1204L | Error | 2881 | 55W33 | "INSERT...ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2" | Insert statement with ON EXISTING clause is not permitted on a base table if the base table has dependent initialized immediate materialized view. Click here for a list of possible parameters and odbc states. |
| -1205L | Error | 2882 | WJ030 | "External environment '%1' could not be found" | You attempted to define an object for an external environment that has not been added. Click here for a list of possible parameters and odbc states. |
| -1206L | Error | 2883 | WW104 | "External environments are not supported for this database" | The current database does not have catalog support for external environments. To use this feature, upgrade your database to the most recent version. Click here for a list of possible parameters and odbc states. |
| -1207L | Error | 2884 | WT016 | "Invalid use of NEAR operator in text query." | Only terms, prefixes, or other NEAR operators are allowed as arguments to a NEAR operator. Click here for a list of possible parameters and odbc states. |
| -1208L | Error | 2885 | WW105 | "Invalid partition bound value '%1'" | The partition bound value is invalid and cannot be used. Click here for a list of possible parameters and odbc states. |
| -1209L | Error | 2886 | WW106 | "Cannot convert value '%1' to an %2" | The value is not compatible with the type of the partition key. Click here for a list of possible parameters and odbc states. |
| -1210L | Error | 2887 | WW107 | "Partition bound value '%1' out of order" | Range partition bound values must be provided in ascending order. Click here for a list of possible parameters and odbc states. |
| -1211L | Error | 2888 | 23509 | "MERGE statement ANSI cardinality violation on table '%1'" | You have attempted to execute the MERGE statement and the same row is the target of a WHEN MATCHED clause more than once Click here for a list of possible parameters and odbc states. |
| -1212L | Error | 2889 | 28W15 | "Connection disallowed by login policy for this user" | A connection attempt was disallowed based on the login policy for the user. It may be necessary for a user with DBA authority to reset this user via the ALTER USER statement. Click here for a list of possible parameters and odbc states. |
| -1213L | Error | 2891 | WJ031 | "External environment does not support result sets" | You attempted to define dynamic result sets for an external environment that does not support result sets. Click here for a list of possible parameters and odbc states. |
| -1214L | Error | 2892 | WW108 | "External library '%1' is in use" | The external library cannot be unloaded as it is currently in use. Click here for a list of possible parameters and odbc states. |
| -1215L | Error | 2893 | WW109 | "External library '%1' not loaded" | The external library cannot be unloaded as it is not current loaded. Click here for a list of possible parameters and odbc states. |