Start of change

-607   OPERATION OR OPTION operation IS NOT DEFINED FOR THIS OBJECT

Explanation

The operation or option cannot be performed on the object specified in the SQL statement.

Examples:
  • LOGGED and NOT LOGGED cannot be set when you create or alter a table space in the DB2® catalog (DSNDB06) database.
  • Catalog and directory objects cannot be cloned.
  • Data change operations such as ALTER TABLE, DELETE, INSERT, MERGE, UPDATE, and RENAME TABLE cannot be performed on directory tables.
  • A period specification must not be used if the table reference is not a table.
  • The operation is a SELECT statement, and a target of the operation is a directory object. DB2 cannot convert the SELECT statement to the UR isolation level. For example, the following SQL statement cannot be executed because the SELECT operation against directory object SYSIBM.SYSLGRNX cannot be converted to the UR isolation level:
    UPDATE T1 SET C1 = (SELECT C1 FROM T1)
  WHERE EXISTS(SELECT LGRDBID FROM SYSIBM.SYSLGRNX);

System action

The statement cannot be processed.

Programmer response

If an option of the SQL statement is not allowed for this object, modify the SQL statement and resubmit the statement. If an operation is not defined for the object, the statement cannot be executed.

SQLSTATE

42832

End of change