Start of change

-7008   object-name NOT VALID FOR OPERATION (reason-code)

Explanation

The object that is specified is not valid for the requested operation.

object-name
The name of the object.
reason-code
The reason for the message or SQL code, indicated by one of the following values:
10
A CREATE VIEW statement was issued, but the view cannot be created because a view cannot be defined on another view for which an INSTEAD OF trigger exists.
17
A CREATE TRIGGER statement was issued, but the trigger cannot be created because an INSTEAD OF trigger cannot be defined on a view that has other views dependent on it, or the view references an accelerator-only table, or an AFTER trigger cannot be defined on a table that has a clone defined.
18
A CREATE INDEX or ALTER INDEX statement was issued, but the index cannot be created at this time because values have not yet been materialized for the row change timestamp column for some of the rows in the table. Issue REORG on the table space containing the table and then try to create the index.
19
A MERGE statement was issued, but the target of a MERGE statement cannot be a view that has an instead of trigger defined for it.
20
No index expression-based index can be created after the inline length is altered until the base table is reorganized.

System action

The statement cannot be processed.

Programmer response

Specify an object for which the operation would be allowed, and reissue the statement.

SQLSTATE

55019

End of change