Messages 182 through 200

SQLDA_TOO_SMALL

2114

07002

-182L

07001

07002

16

There are not enough fields in the SQLDA to retrieve all of the values requested.

INDEX_NOT_FOUND

2063

52W03

-183L

S0012

42S12

16

Name of the index that cannot be found.

You attempted to perform an operation using an index that does not exist. Check for spelling errors. Check whether the index name must be qualified with a user ID.

COLUMN_CANNOT_BE_NULL_LOAD_TABLE

2531

23501

-184L

23000

23000

16

Name of the column that cannot be NULL.

Name of the table containing the column.

The line number of the data file containing the invalid data.

You either have not supplied a value where a value is required or a data conversion was necessary that resulted in a NULL value. The column definition prohibits NULL values or the column is part of a NOT NULL foreign key.

TOO_MANY_RECORDS

2116

21000

-185L

ERROR

ERROR

16

You tried to use a SELECT statement without a cursor, but the statement cursor returns more than one row. Only a single row SELECT statement can be used in this context.

SUBQUERY_RESULT_NOT_UNIQUE

2117

21W01

-186L

37000

42000

16

You used a subquery that returns more than one row, in a context where only a single row can be used. If the subquery is in the WHERE clause, you might be able to use the IN keyword.

CURSOROP_NOT_ALLOWED

2118

09W02

-187L

07005

07005

16

You attempted an illegal cursor operation. For example, you may be attempting to OPEN a cursor for a statement that is neither a SELECT nor a BATCH.

NOT_ENOUGH_HOST_VARS

2119

07001

-188L

07002

07002

16

You have not provided enough host variables for either the number of bind variables, or the statement, or the number of SELECT list items.

NOT_FOUND_IN_INDEX

2120

WI005

-189L

ERROR

ERROR

11

Name of invalid index.

Name of table containing the invalid index.

This is an internal error. If it can be reproduced, it should be reported to iAnywhere. You should be able to work around the error by dropping and recreating the index.

NON_UPDATEABLE_COLUMN

2121

53W02

-190L

37000

42000

14

You tried to update a column in a query that is a database expression rather than a column in a table.

CANNOT_MODIFY

2122

42W32

-191L

42000

42000

14

Name of the column that cannot be changed.

Name of the table containing the column.

You may have tried to modify a column that you do not have permission to modify. You may have tried to modify a column defined as an expression (such as column1+column2) in a view.

NON_UPDATEABLE_VIEW

2123

42W31

-192L

42000

42000

15

You attempted an insert, update, or delete operation on a query that is implicitly read-only. Queries that contain DISTINCT, GROUP BY, HAVING, EXCEPT, INTERSECT or UNION, or that contain aggregate functions, or that involve a join, are implicitly read-only. If the query references a view then the view may be non-updatable.

PRIMARY_KEY_NOT_UNIQUE

2124

23W01

-193L

23000

23000

14

Name of the table where the problem was detected.

Duplicate primary key values that caused the error.

You attempted to add a new row to a table, but the new row has the same primary key as an existing row. The database has not added the incorrect row to the database. For example, you might have added a student with student number 86004 and there is already a row for a student with that number.

INVALID_FOREIGN_KEY

2125

23503

-194L

23000

23000

16

Name of the foreign key.

Name of the table with the foreign key.

You attempted to insert or update a row that has a foreign key for another table. The value for the foreign key is not NULL and there is not a corresponding value in the primary key.

COLUMN_CANNOT_BE_NULL

2126

23502

-195L

23000

23000

16

Name of the column that cannot be NULL.

Name of the table containing the column.

You have not supplied a value where a value is required. The column definition prohibits NULL values or the column is part of a NOT NULL foreign key.

INDEX_NOT_UNIQUE

2127

23505

-196L

23000

23000

16

Name of the index that would not be unique.

Name of the table that contains the index.

You attempted to insert or update a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column.

NO_CURRENT_ROW

2128

24503

-197L

24000

24000

16

You attempted to perform an operation on the current row of a cursor, but the cursor is not positioned on a row. The cursor is before the first row of the cursor, after the last row, or is on a row that has since been deleted.

PRIMARY_KEY_VALUE_REF

2129

23W05

-198L

23000

23000

16

The name of the table containing the row being modified.

The name of the foreign index (or role) of the referencing table.

The name of the foreign table referencing the primary row.

You attempted to delete or modify a row whose primary key value is referenced elsewhere in the database.

ONLY_ONE_TABLE

2130

09W04

-199L

37000

42000

15

You attempted to insert into a cursor and have specified values for more than one table, or you attempted to delete from a cursor that involves a join. Insert into one table at a time. For DELETE, use the FROM clause to specify the table you want to delete from.

WARNING

2009

01000

200L

OK

OK

10

Warning message.

A warning has occurred. The message indicates the condition that caused the warning.

INVALID_OPTION

2167

42W16

-200L

37000

42000

15

Name of the invalid option.

You may have misspelled the name of an option in the SET OPTION statement. You can only define an option for a user if the database administrator has supplied a PUBLIC value for that option.