-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