-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.
System action
The statement cannot be processed.
Programmer response
Correct the syntax and resubmit the statement.
SQLSTATE
428C7