-867   INVALID SPECIFICATION OF A ROWID COLUMN

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 can not be added to a temporary table.
• The referential-constraint clause can not specify a ROWID column as a column of a foreign key.
• A ROWID column can not be a column of a primary key.
• A ROWID column can not be a column in a table with an edit procedure that is defined with row attribute sensitivity.

If more than one exchange is attempted consecutively, then there must be a COMMIT between them. This COMMIT is already required before DML can be done. If a COMMIT is not done between exchanges, then a -909 SQL code will be issued.