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 |
|---|---|---|---|---|---|
| -151L | Error | 2094 | 53023 | "Subquery allowed only one select list item" | You entered a subquery that has more than one column in the select list. Change the select list to have only one column. Click here for a list of possible parameters and odbc states. |
| -152L | Error | 2095 | 53005 | "Invalid ORDER BY specification" | Either you used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list, or you specified an ORDER BY expression that is semantically invalid. For example, with UNION queries you can only use integers to specify an ordering of the result. Click here for a list of possible parameters and odbc states. |
| -153L | Error | 2096 | 53026 | "Select lists in UNION, INTERSECT, or EXCEPT do not match in length" | You specified a UNION, INTERSECT, or EXCEPT but the SELECT statements involved in the operation do not have the same number of columns in the select list. Click here for a list of possible parameters and odbc states. |
| -154L | Error | 2100 | 37505 | "Wrong number of parameters to function '%1'" | You supplied an incorrect number of parameters to a database function. Click here for a list of possible parameters and odbc states. |
| -155L | Error | 2102 | 42W07 | "Invalid host variable" | You supplied an invalid host variable to the database using the C language interface. You may have supplied the variable as a host variable or through a SQLDA. Click here for a list of possible parameters and odbc states. |
| -156L | Error | 2103 | 42W08 | "Invalid expression near '%1'" | You supplied an expression that the database server cannot understand. For example, you may have tried to add two dates. Click here for a list of possible parameters and odbc states. |
| -157L | Error | 2104 | 53018 | "Cannot convert %1 to a %2" | An error occurred while trying to convert a value to another data type. Click here for a list of possible parameters and odbc states. |
| -158L | Error | 2105 | 22003 | "Value %1 out of range for destination" | You supplied to or fetched from the database a value that is out of range for the destination column or host variable. For example, the value 10 may have been supplied for a DECIMAL(3,2) field. Click here for a list of possible parameters and odbc states. |
| -159L | Error | 2106 | 42W13 | "Invalid column number" | You gave an invalid column number, or the column you are looking for is in a different table. Click here for a list of possible parameters and odbc states. |
| -160L | Error | 2107 | 07005 | "Can only describe a SELECT statement" | In the C language interface, you attempted to describe the select list of a statement other than a SELECT statement. In UltraLite this error can result from trying to retrieve the schema of any statement other than a SELECT. Click here for a list of possible parameters and odbc states. |
| -161L | Error | 2108 | 07W01 | "Invalid type on DESCRIBE statement" | A Java type specified on a DESCRIBE statement has no corresponding SQL type. Click here for a list of possible parameters and odbc states. |
| -162L | Error | 2533 | 53017 | "Cannot convert %1 to a %2. The bad value was supplied for column '%3' on row %4 of the data file" | The data file supplied to LOAD TABLE contains a value that cannot be converted to the required data type. Click here for a list of possible parameters and odbc states. |
| -163L | Error | 2302 | 52004 | "Derived table '%1' has no name for column %2" | The specified column of the derived table has no column name. Use a select list alias in the query specification or use a derived columns specifier. Click here for a list of possible parameters and odbc states. |
| -164L | Error | 2310 | WP007 | "Namespace heap exhausted at internal function: %1" | The amount of space allocated for the Java Namespace is insufficient to continue loading Java classes. Increase the size by using: SET OPTION PUBLIC.java_namespace_size = nnnnnnnn. Click here for a list of possible parameters and odbc states. |
| -165L | Error | 2311 | WP008 | "Java VM heap exhausted at internal function: %1" | The amount of space allocated for the Java VM is insufficient to continue allocating new objects. Increase the size by using: SET OPTION PUBLIC.java_heap_size = nnnnnnnn. Click here for a list of possible parameters and odbc states. |
| -170L | Error | 2109 | 24W01 | "Cursor has not been declared" | You attempted to OPEN a cursor that has not been declared. Click here for a list of possible parameters and odbc states. |
| -171L | Error | 2110 | 07003 | "Error opening cursor" | You attempted to open a cursor on a statement that is not SELECT, CALL or EXEC. Click here for a list of possible parameters and odbc states. |
| -172L | Error | 2111 | 24502 | "Cursor already open" | You attempted to OPEN a cursor that is already open. Click here for a list of possible parameters and odbc states. |
| -180L | Error | 2112 | 24501 | "Cursor not open" | You attempted to use a cursor that has not been opened. Click here for a list of possible parameters and odbc states. |
| -181L | Error | 2113 | 22002 | "No indicator variable provided for NULL result" | You tried to retrieve a value from the database that was NULL, but you did not provide an indicator variable for that value. Click here for a list of possible parameters and odbc states. |