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 |
|---|---|---|---|---|---|
| -964L | Error | 2628 | 42WA8 | "Window function used in predicate" | A window function was used in the WHERE or HAVING clause of a SELECT statement. Consider making the SELECT into a derived table, putting the window function in the SELECT list of the derived table, and changing the predicate to reference the derived column. Click here for a list of possible parameters and odbc states. |
| -965L | Error | 2629 | 42WA9 | "Window function requires ORDER BY" | Rank functions and window functions that use the RANGE keyword must specify an ORDER BY clause. Click here for a list of possible parameters and odbc states. |
| -966L | Error | 2630 | 42WAA | "Composite ORDER BY not allowed with RANGE" | Window functions that use the RANGE keyword may only ORDER BY a single column. Click here for a list of possible parameters and odbc states. |
| -967L | Error | 2631 | WB012 | "Backup file '%1' already exists" | A file that would normally be created by this BACKUP statement already exists. Click here for a list of possible parameters and odbc states. |
| -968L | Error | 2632 | 42WAB | "User '%1' already has EXECUTE permission" | You attempted to give EXECUTE permission on a stored procedure to a user that already has EXECUTE permission on that procedure. Click here for a list of possible parameters and odbc states. |
| -969L | Error | 2633 | WI011 | "Required operators excluded" | The database server was unable to construct a valid access plan for the given request because required data flow operators were excluded by the exclude_operators option. Re-enable the required operators to execute the statement. Click here for a list of possible parameters and odbc states. |
| -970L | Error | 2634 | 42U07 | "Invalid hint specified for table '%1'" | A hint was specified for the current statement is not valid in this context. In a single statement, all references to a table must specify the same hint or none at all. Click here for a list of possible parameters and odbc states. |
| -971L | Error | 2637 | WW042 | "Checksums are not enabled in this database" | An attempt was made to perform checksum validation but the database does not have checksums enabled. Click here for a list of possible parameters and odbc states. |
| -972L | Error | 2638 | 54W03 | "Database page size too small: %1" | You attempted to load statistics that were too large for the current database page size. Rebuilding this database with a larger page size could prevent this error. Click here for a list of possible parameters and odbc states. |
| -973L | Error | 2639 | 54W06 | "The string is too long (%1)" | The string is longer than that allowed by the server. Click here for a list of possible parameters and odbc states. |
| -974L | Error | 2640 | WW043 | "File I/O failed for '%1'" | An error occurred while trying to access the file. If the file is located on a removable media card, the card may have been removed. Click here for a list of possible parameters and odbc states. |
| -975L | Error | 2641 | WW044 | "Incorrect volume ID for '%1'" | The file can be accessed, but the volume ID has changed. Insert the original removable media card. Click here for a list of possible parameters and odbc states. |
| -976L | Error | 2643 | 08W70 | "Could not load the encryption DLL \"%1\No message | An attempt to load the encryption DLL failed. Click here for a list of possible parameters and odbc states. |
| -978L | Error | 2645 | WW047 | "Directory for output file does not exist" | The file cannot be written because the directory does not exist. Click here for a list of possible parameters and odbc states. |
| -979L | Error | 2646 | WW048 | "Output file cannot be written" | Unable to create or write an output file. The file may be locked or read-only. Click here for a list of possible parameters and odbc states. |
| -980L | Error | 2647 | WW049 | "The URI '%1' is invalid" | The specified URI is not valid. Click here for a list of possible parameters and odbc states. |
| -981L | Error | 2648 | WW050 | "Unable to connect to the remote host specified by '%1'" | A connection could not be initiated to the remote server. Click here for a list of possible parameters and odbc states. |
| -982L | Error | 2649 | WW051 | "Connection timed out" | The connection to the remote host timed out due to inactivity. Click here for a list of possible parameters and odbc states. |
| -983L | Error | 2650 | WW052 | "HTTP request failed. Status code '%1'" | The HTTP request returned a status code that indicated failure. Click here for a list of possible parameters and odbc states. |
| -984L | Error | 2651 | WW053 | "Could not initialize the encryption DLL: '%1'" | An attempt to initialize the encryption DLL failed. Click here for a list of possible parameters and odbc states. |