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 |
|---|---|---|---|---|---|
| 42W46 | Error | 2256 | -204L | "Only the DBA can set the option '%1'" | The option specified in the SET OPTION statement can only be set by a user with DBA authority. Click here for a list of possible parameters and odbc states. |
| 42W47 | Error | 2101 | -615L | "Parameter '%1' not found in procedure '%2'" | You supplied a procedure parameter name that does not match a parameter for this procedure. Check the spelling of the parameter name. Click here for a list of possible parameters and odbc states. |
| 42W48 | Error | 2072 | -687L | "Syntax error, cannot specify IQ specific options without specifying IQ PATH" | The database server cannot understand the statement you are trying to execute. If you used a keyword (such as DATE) for a column name, try enclosing the keyword in quotation marks ("DATE"). Click here for a list of possible parameters and odbc states. |
| 42W49 | Error | 2330 | -702L | "TRUNCATE TABLE statement cannot be used on a view" | You attempted to use TRUNCATE TABLE on a view, which is not permitted. Click here for a list of possible parameters and odbc states. |
| 42W50 | Error | 2336 | -708L | "READTEXT or WRITETEXT statement cannot refer to a view" | A Transact-SQL READTEXT or WRITETEXT statement cannot refer to text columns in a view. Replace the view reference with the name of a base table. Click here for a list of possible parameters and odbc states. |
| 42W51 | Error | 2349 | -720L | "VALIDATE statement must refer to a base table" | The VALIDATE statement must refer to a local base table; it cannot refer to a view, an IQ table, or an object on a remote server. Click here for a list of possible parameters and odbc states. |
| 42W52 | Error | 2351 | -216L | "The option '%1' can only be set as a temporary option" | The option specified in the SET OPTION statement can only be set as a temporary option. Click here for a list of possible parameters and odbc states. |
| 42W53 | Error | 2352 | -217L | "The option '%1' cannot be set from within a procedure" | The option specified in the SET OPTION statement cannot be set from within a procedure. Click here for a list of possible parameters and odbc states. |
| 42W54 | Error | 2382 | -737L | "Signature '%1' does not match procedure parameters" | The number of types in the signature must match the number of procedure parameters. If a DYNAMIC RESULT SETS clause was specified, the number of dynamic result sets must match the quantity found in the signature. Click here for a list of possible parameters and odbc states. |
| 42W55 | Error | 2396 | -750L | "User owns procedures in use" | You attempted to drop a user that owns a procedure being used by other active users of the database. Click here for a list of possible parameters and odbc states. |
| 42W56 | Error | 2397 | -751L | "User owns tables in use" | You attempted to REVOKE CONNECT from a user that owns a table being used by other active users of the database. Click here for a list of possible parameters and odbc states. |
| 42W57 | Error | 2457 | -810L | "External object '%1' not found" | The Java class or external object with this name does not exist in the database. Click here for a list of possible parameters and odbc states. |
| 42W58 | Error | 2458 | -811L | "JAR '%1' not found" | The JAR with this name does not exist in the database. Click here for a list of possible parameters and odbc states. |
| 42W59 | Error | 2459 | -812L | "The select list for the derived table '%1' has no expression to match '%2'" | The specified alias from the derived table's AS clause has no matching expression from the SELECT statement for that derived table. Ensure that each select list item has a matching alias in the derived table's AS clause, and vice-versa. Click here for a list of possible parameters and odbc states. |
| 42W60 | Error | 2477 | -830L | "Alias '%1' is not unique" | The same alias is used more than once in a select list. Click here for a list of possible parameters and odbc states. |
| 42W61 | Error | 2478 | -831L | "Definition for alias '%1' must appear before its first reference" | An expression contains a reference to an alias, but the alias is defined later in the select list. The alias definition must appear before its first reference. Click here for a list of possible parameters and odbc states. |
| 42W62 | Error | 2480 | -833L | "Row in table '%1' was modified or deleted in BEFORE trigger" | A BEFORE trigger has updated or deleted the row that caused the trigger to fire, preventing the original operation from completing. The trigger must be re-written so that it does not attempt to change the row via UPDATE or DELETE statements. Click here for a list of possible parameters and odbc states. |
| 42W63 | Error | 2483 | -836L | "Procedure '%1' is no longer valid" | A procedure definition cannot be loaded from the catalog. Check for tables or columns that have been renamed or that may be reserved words. Click here for a list of possible parameters and odbc states. |
| 42W64 | Error | 2484 | -837L | "Trigger or foreign key for table '%1' is no longer valid" | A trigger definition cannot be loaded from the catalog. Check for tables or columns that have been renamed or that may be reserved words. The trigger may be a system-generated trigger to enforce the referential actions of a foreign key. Click here for a list of possible parameters and odbc states. |
| 42W65 | Error | 2502 | -854L | "Function or column reference to '%1' in the ORDER BY clause is invalid" | You specified a function or column reference in the ORDER BY clause that is semantically invalid. For example, for DISTINCT queries the ORDER BY clause may only refer to items in the query's select list. Click here for a list of possible parameters and odbc states. |