-771 INVALID SPECIFICATION OF A ROWID COLUMN
Explanation
For an ALTER TABLE or CREATE TABLE statement, the specification of a ROWID column might be invalid for one of the following reasons:
- A ROWID column cannot be added to a temporary table.
- A ROWID column cannot be specified in a referential-constraint clause as a column of a foreign key.
- A ROWID column cannot be a column of a primary key or unique key.
- A ROWID column cannot be a column in a table with an edit procedure that is defined with row attribute sensitivity.
- A ROWID column cannot be part of the implicit or explicit column list for fullselect in the as-result-table clause of a CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement.
- A ROWID column that is implicitly generated cannot be dropped.
- A ROWID column that is defined as GENERATED BY DEFAULT cannot be dropped if the table contains an implicitly generated ROWID column.
- A ROWID column cannot be dropped if the table contains LOB columns that are dependent on the ROWID column.
System action
The statement cannot be processed.
Programmer response
Correct the syntax and resubmit the statement.
SQLSTATE
428C7