-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 for an index on a table that is not empty. One of the columns in the index key is a row change timestamp column that was added to the table after it was created. 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.

51

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.

52

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.

62

A DELETE statement with a fetch-clause was issued, and the target of the statement is a view that is defined with an INSTEAD OF trigger. A DELETE statement with a fetch-clause is not supported when issued against a view that is defined with an INSTEAD OF trigger.