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 |
|---|---|---|---|---|---|
| WO015 | Error | 2354 | -721L | "The data type specified for column '%1' is not compatible with the actual data type" | The data type of the column specified in the CREATE EXISTING statement is not compatible with the actual data type of the column in the remote table. Click here for a list of possible parameters and odbc states. |
| WO016 | Error | 2355 | -722L | "The column '%1' does not exist in the remote table" | The column specified in the CREATE EXISTING statement does not exist in the remote table. Click here for a list of possible parameters and odbc states. |
| WO017 | Error | 2356 | -723L | "The length specified for column '%1' is different than the actual length" | The length of the column specified in the CREATE EXISTING statement is different than the length of the column in the remote table. Click here for a list of possible parameters and odbc states. |
| WO018 | Error | 2357 | -724L | "NULL attribute mismatch for column '%1'" | The NULL attribute of the column specified in the CREATE EXISTING statement differs from the NULL attribute of the actual column. Click here for a list of possible parameters and odbc states. |
| WO019 | Error | 2358 | -725L | "Identity attribute mismatch for column '%1'" | The identity attribute of the column specified in the CREATE EXISTING statement differs from the identity attribute of the actual column. Click here for a list of possible parameters and odbc states. |
| WO020 | Error | 2359 | -726L | "The table specification '%1' identifies more than one remote table" | More than one table was found on the remote server for the given table specification. Add a database or owner name to the specification. Click here for a list of possible parameters and odbc states. |
| WO021 | Error | 2366 | -732L | "Creating remote tables with computed columns is not supported" | Computed columns are not supported in CREATE TABLE statements that specify a remote location. Click here for a list of possible parameters and odbc states. |
| WO022 | Error | 2367 | -736L | "The data type of column or variable '%1' is not supported" | The column is defined with a data type that is not supported for remote tables or the variable is defined with a datatype that is not supported for using and location clauses. Click here for a list of possible parameters and odbc states. |
| WO023 | Error | 2470 | -823L | "Cannot handle expressions involving remote tables inside stored procedures" | The server encountered an expression involving remote tables inside a stored procedure. The expression was too complicated to process. Click here for a list of possible parameters and odbc states. |
| WO024 | Error | 2663 | -996L | "Specified local connection ID not found" | There is no connection with the specified connection ID. Click here for a list of possible parameters and odbc states. |
| WO025 | Error | 2664 | -997L | "Local connection ID does not refer to the current database" | The specified connection ID is for a connection to a database other than the current database. Click here for a list of possible parameters and odbc states. |
| WO026 | Error | 2665 | -998L | "Cannot close a remote JDBC connection that is not the current connection" | When attempting to close a remote JDBC connection, the specified connection must be the local connection. Click here for a list of possible parameters and odbc states. |
| WO027 | Error | 2735 | -1066L | "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. |
| WO028 | Error | 2898 | -1220L | "User cannot be dropped because external logins exist for this user." | The user cannot be dropped while an external login for the user still exists. Click here for a list of possible parameters and odbc states. |
| WO031 | Error | 3221 | -1579L | "External procedures or functions are not allowed across server types." | External procedure or function calls are not allowed across server types if the query is not processed in full-passthrough mode. Click here for a list of possible parameters and odbc states. |
| WO032 | Error | 3232 | -1590L | "You cannot use a security token when making remote connections" | A security token cannot be used to make remote data access connections Click here for a list of possible parameters and odbc states. |
| WO034 | Error | 3260 | -1618L | "The %1 remote data access class has been deprecated, please use %2 instead or change cis_option" | You attempted to use a JDBC based remote data access class which has been deprecated. Please use the appropriate ODBC based class instead; or change the cis_option setting to re-enable this feature. Click here for a list of possible parameters and odbc states. |
| WP000 | Error | 2267 | -90L | "Argument %1 of procedure '%2' cannot be NULL" | You passed a NULL value to a procedure expecting a scalar argument. For example, a Java procedure that has an 'int' argument cannot receive a NULL value. Click here for a list of possible parameters and odbc states. |
| WP001 | Error | 2268 | -91L | "Procedure '%1' terminated with unhandled exception '%2'" | A Java procedure terminated with an active exception, and this exception is reflected in SQL as an error status. Click here for a list of possible parameters and odbc states. |
| WP002 | Error | 2269 | -92L | "'%1' is not a valid class file" | A file passed to the INSTALL JAVA statement was not a valid Java class file. Click here for a list of possible parameters and odbc states. |