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 |
|---|---|---|---|---|---|
| -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. |
| -1068L | Error | 2737 | 52W43 | "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. |
| -1069L | Error | 2738 | 28W12 | "Kerberos login failed" | The Kerberos login failed due to a failure of the client to authenticate the user's principal with the KDC or a failure of the server to authenticate the client. The most likely causes are the Kerberos principal may not be signed in, the principal's ticket may have expired, or the client, server, or KDC's system time are not within a few minutes of each other. The LogFile connection parameter or the server's -z option may provide more information. Click here for a list of possible parameters and odbc states. |
| -1070L | Error | 2739 | 28W13 | "Kerberos logins are not supported" | The client and/or server does not support Kerberos logins. Kerberos may not be supported by the platform, the Kerberos client software including the GSS-API runtime may not be installed or found on the client, or Kerberos was not enabled on the server. The LogFile connection parameter or the server's -z option may provide more information. Click here for a list of possible parameters and odbc states. |
| -1071L | Error | 2740 | 0AW16 | "The %1 algorithm is not available in FIPS mode" | The specified algorithm is not available when the server is running in FIPS mode. Click here for a list of possible parameters and odbc states. |
| -1072L | Error | 2741 | WC009 | "'%1' is not a valid character set encoding for use with collation '%2'" | The specified character set cannot be used with the specified collation. Click here for a list of possible parameters and odbc states. |
| -1073L | Error | 2742 | WC010 | "'%1' cannot be used as the NCHAR collation: only UCA and UTF8BIN may be used" | The specified collation cannot be used as the NCHAR collation. NCHAR always uses UTF-8, so the collation must be either UCA or UTF8BIN. Click here for a list of possible parameters and odbc states. |
| -1074L | Error | 2743 | 28W14 | "Login mode '%1' not permitted by login_mode setting" | You attempted to connect using a login mode not included in the current login_mode database option setting. Change the option setting or connect using a different login mode. Click here for a list of possible parameters and odbc states. |