Start of change

-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

End of change