-20092   A TABLE OR VIEW WAS SPECIFIED IN THE LIKE CLAUSE, BUT THE OBJECT CANNOT BE USED IN THIS CONTEXT

Explanation

The LIKE clause specified the name of a table or view that is not valid for one of the following reasons:
  • If the object is a view, it is not allowed in the LIKE clause because the view includes a ROWID or XML column. This is not supported.
  • If the object is a table, it is not allowed in the LIKE clause because it is defined as a clone of another table.

System action

The statement cannot be processed.

Programmer response

Specify the name of a view that does not contain a ROWID column (or distinct type column for which the source type is ROWID), or specify the name of a table and resubmit the statement.

Specify the name of a table that is not a clone table, if you specified a table in the LIKE clause that is defined as the clone of another table.

SQLSTATE

560AE