-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