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 |
|---|---|---|---|---|---|
| -915L | Error | 2580 | 42W92 | "Service type required for CREATE SERVICE" | The CREATE SERVICE statement requires a service type to be specified. Click here for a list of possible parameters and odbc states. |
| -916L | Error | 2581 | 42W94 | "'%1' is an unrecognized service type" | An unrecognized service type was specified. Click here for a list of possible parameters and odbc states. |
| -918L | Error | 2583 | 42W96 | "A user name must be specified if AUTHORIZATION is Off" | A valid user name must be specified if AUTHORIZATION is Off. Click here for a list of possible parameters and odbc states. |
| -919L | Error | 2584 | 42W97 | "Service '%1' already exists" | You have attempted to create a service with a name that already exists in the database. Click here for a list of possible parameters and odbc states. |
| -920L | Error | 2585 | 42W98 | "Service '%1' not found" | You have attempted to reference a service with a name that does not exist in the database. Click here for a list of possible parameters and odbc states. |
| -921L | Error | 2586 | 42W99 | "Invalid recursive query" | A recursive query must consist of the UNION ALL of an initial query and an iteration query. The only set operation allowed in the iteration query is UNION ALL. A recursive reference to the name of the common table expression can only appear in the iteration query, and must not be in a SELECT that uses DISTINCT, ORDER BY, or an aggregate function. A recursive reference also cannot appear on the NULL-supplying side of an outer join, or in a subquery. Click here for a list of possible parameters and odbc states. |
| -922L | Error | 2587 | 42W9A | "No column list for recursive query" | A common table expression defining a recursive query must have a column list. Click here for a list of possible parameters and odbc states. |
| -923L | Error | 2588 | 57015 | "Too many recursive iterations" | A recursive query ran for more iterations than allowed by the current max_recursive_iterations option setting. Click here for a list of possible parameters and odbc states. |
| -924L | Error | 2582 | 55W15 | "Service '%1' in use" | You have attempted to drop a service that is currently in use. Click here for a list of possible parameters and odbc states. |
| -925L | Error | 2589 | 42W95 | "Invalid service name '%1'" | You have attempted to create a service with an invalid name. The name may contain characters that are not allowed, or it may conflict with the URL PATH setting specified for the service. Click here for a list of possible parameters and odbc states. |
| -926L | Error | 2590 | 42W9B | "Host variable reference in service definition must be named" | You have attempted to create a service with an unnamed host variable reference. Click here for a list of possible parameters and odbc states. |
| -927L | Error | 2591 | 42W9C | "Service statement definition is inconsistent with service type" | Either no statement was provided for a service whose type requires one, or a statement was provided when the service type does not allow one to be defined. Click here for a list of possible parameters and odbc states. |
| -928L | Error | 2592 | 42W9D | "Constant expressions must not appear in GROUP BY clause" | You used a constant in the GROUP BY clause. Constants must not appear in the GROUP BY clause for a query. References to columns in a view that are constant are permitted in a GROUP BY clause. Also, expressions that use a view column that is constant are permitted. Click here for a list of possible parameters and odbc states. |
| -929L | Error | 2593 | 42U04 | "Constraint '%1' not found" | You misspelled the name of a constraint, or the constraint you are looking for is on a different table. Click here for a list of possible parameters and odbc states. |
| -930 | Error | 2594 | 42U05 | No message | You have asked for an unnamed column constraint to be altered, but there is at least one named constraint. Click here for a list of possible parameters and odbc states. |
| -931L | Error | 2595 | 42W9E | "Service definition requires a statement when authorization is off" | The service definition for the specified service type requires a statement to be specified when authorization is set to Off. Click here for a list of possible parameters and odbc states. |
| -933L | Error | 2597 | 0AQ48 | "A log is required for IQ databases" | IQ databases require the use of a transaction log file. Click here for a list of possible parameters and odbc states. |
| -934L | Error | 2598 | 08W67 | "Unable to start specified database: Server must be upgraded to start database %1" | The database server was unable to start the database since the database version is newer than the server version. The server must be upgraded to at least the version of the database to be able to start the database. Click here for a list of possible parameters and odbc states. |
| -935L | Error | 2599 | 08W68 | "Unable to start specified database: Log file error" | The database server was unable to start the database since the log file is missing, for a different database, or some other reason. Check the server window messages area for more details. Click here for a list of possible parameters and odbc states. |
| -936L | Error | 2600 | 54W02 | "Too many constraints in database" | An attempt to create a new constraint failed because the corresponding system table is full. Reloading the database will reclaim any unused space. Click here for a list of possible parameters and odbc states. |