SQL error codes (-nnnn)

SQL Codes that are issued when processing an SQL statement.

0
This is a successful run.
-60
The length or scale is not valid.
-84
The SQL statement cannot be executed.
-102
The literal string is too long. The maximum allowable size is size. The string begins with string.
-104
token is an incorrect token.
-107
The name, name is too long. The maximum allowable size is size.
-109
clause clause is not permitted.
-112
The operand of a column function is another column function.
-113
There is an incorrect character in: string, reason code nnn.
-117
The number of insert columns must match the number of insert values.
-119
A column that was identified in a HAVING clause must be included in the GROUP BY clause.
-120
A WHERE clause or SET clause includes an aggregate column function.
-121
An INSERT or UPDATE statement references a column for update multiple times.
-122
The SELECT statement with a no GROUP BY clause contains a column name and a column function in the SELECT clause, or a column name is contained in the select clause, but not in the GROUP BY clause.
-125
An integer in the ORDER BY clause must identify a column of the result.
-126
The SELECT statement contains both an ORDER BY clause and an UPDATE clause.
-127
The DISTINCT qualifier is specified more than once in a subselect.
-129
There are too many tables referenced in a single query.
-134
There is an improper use of the LONG STRING COLUMN or a host variable of a MAXIMUM LENGTH greater than 254.
-138
The SUBSTRING argument is not valid.
-150
An INSERT, UPDATE, or DELETE statement was issued on a view.
-151
An UPDATE was issued on a non-updateable column.
-153
A CREATE VIEW statement must have a column-name list.
-156
The target of a MAP INDEX statement must be a table.
-158
The column list for view is not valid.
-170
The number of arguments is not valid.
-171
The function argument is not valid.
-181
The string representation of a DATETIME value is not valid.
-182
An arithmetic expression with a DATETIME value is not valid.
-183
An arithmetic operation on a DATE or TIMESTAMP value produced a value that is out of the range of the valid dates.
-185
The LOCAL date and time format is not supported.
-199
The keyword, keyword is not valid.
-203
A reference to a column name is ambiguous.
-204
The name is an undefined name.
-205
The column, column-name is not a column in the table, table-name.
-206
The column-name must be a column in an inserted table, updated table, or any table that is identified in a FROM clause.
-208
A column that is not valid is included in the ORDER BY clause.
-300
The host variable is not null terminated.
-301
The input-host variable type is not valid.
-302
The host variable is not valid or too large for the target column.
-303
The output-host variable type is not valid.
-304
Conversion of SQL data type would result in truncated value.
-305
An output-indicator variable was not given.
-312
CREATE VIEW statement contains parameter markers or host variables.
-313
The number of host variables is incorrect.
-338
The ON clause for a table join is not valid.
-401
The operands of an arithmetic or comparison operation are not comparable.
-402
An expression in a select list contains operands that are not compatible.
-405
The numeric literal is out of range.
-407
An UPDATE or INSERT value is NULL, and the target column is defined as NOT NULL.
-408
An UPDATE or INSERT value is not compatible with the data type of the target column.
-412
The SELECT CLAUSE of a subquery specifies multiple columns.
-415
The corresponding columns in each table of a UNION do not have the compatible data types.
-416
There is an operand of a UNION that contains a long SQL column.
-419
The decimal-divide operation is not valid.
-420
There is an incorrect decimal string.
-421
The operands of a UNION do not have the same number of result columns.
-444
The stored procedure failed to load.
-469
The stored procedure definition includes one or more OUTPUT parameters for which no host variable was passed.
-501
The cursor that is identified in a FETCH or CLOSE statement is not open.
-502
The cursor that is identified in an OPEN statement is already open.
-504
The cursor name is not defined.
-514
The cursor is not in a prepared state.
-516
The DESCRIBE statement does not identify a PREPARED statement.
-517
The statement that is named in the declaration for the cursor must be a SELECT statement.
-518
The statement is not prepared.
-519
The PREPARE statement identifies the SELECT statement of the opened cursor.
-530
The foreign key was incorrect. The insert positioning failed on a multi-record mapped table.
-537
The primary key clause identifies the column, column-name more than once.
-542
The column-name cannot be a column of a primary key because it can contain null values.
-551
Privileges are necessary to run the SQL statement.
-601
The name of the object to be created cannot be identical to the existing name.
-602
The CREATE INDEX statement specifies too many columns (number is the maximum).
-604
A data type definition specifies an incorrect length, precision, or scale attribute for column-name.
-607
An INSERT, UPDATE, or DELETE statement was issued on a non-updateable table.
-612
A duplicate column name is specified.
-637
Duplicate keyword. keyword.
-638
The table, table, cannot be created because a column definition is missing.
-644
An incorrect value, value, is specified for the keyword or clause, keyword-or-clause in the statement, stmt-type.
-681
An error occurred while a column in a field procedure was being encoded or decoded.
-682
The program cannot load the field procedure.
-802
The SQL statement caused a data exception error.
-803
Duplicate keys were detected on table table-name.
-804
The input SQLDA is incorrect.
-811
The results of a subselect produced more than one row.
-817
An update is prohibited. A two-phase-commit situation or a catalog update statement (DDL) was issued while another connector transaction was incomplete.
-870
The number of host variables is incorrect.
-904
An unavailable resource prevented the SQL statement from running.
-922
Authorization for the connection failed.
-4901
The cursor limit was exceeded.
-4902
The memory limit was exceeded.
-4903
The SQL statement is unsupported.
-4904
The SQL function or expression is not supported.
-4905
An internal processing error occurred.
-4906
The conversion is not valid.
-4907
An internal catalog error occurred while reading or updating the system catalog.
-4908
The mapped data is not valid.
-4909
A DDLEX mapping error occurred.
-4910
An error occurred during a connector update that required a backout of the current transaction.
-4911
The statement processing was cancelled.

Parent topic: System messages