-20091   A VIEW NAME WAS SPECIFIED AFTER LIKE IN ADDITION TO THE INCLUDING IDENTITY COLUMN ATTRIBUTES CLAUSE

Explanation

The LIKE clause specified the name of a view in combination with the INCLUDING IDENTITY COLUMN ATTRIBUTES clause. This usage is not supported.

System action

The statement cannot be processed.

Programmer response

Remove the INCLUDING IDENTITY COLUMN ATTRIBUTES clause and resubmit the statement to copy the existing view definition without the identity column attributes.

In the case of DECLARE GLOBAL TEMPORARY TABLE, it is possible to get the identity column attributes for a column of a view using the AS subselect clause with INCLUDING IDENTITY COLUMN ATTRIBUTES instead. For example:
DECLARE GLOBAL TEMPORARY TABLE ....
  AS (SELECT * FROM view-name) DEFINITION ONLY
  INCLUDING IDENTITY COLUMN ATTRIBUTES

SQLSTATE

560AD