Start of change

-372   ONLY ONE ROWID, IDENTITY, ROW CHANGE TIMESTAMP, ROW BEGIN, ROW END, TRANSACTION START ID, OR SECURITY LABEL COLUMN IS ALLOWED IN A TABLE

Explanation

An attempt was made to modify or create a table to have two columns of the same type when only one column of that type is permitted in a table.

A table cannot have two or more columns of the following types:

  • ROWID
  • Identity
  • ROW CHANGE TIMESTAMP
  • ROW BEGIN
  • ROW END
  • TRANSACTION START ID
  • Security label

System action

The statement cannot be processed.

Programmer response

For a CREATE TABLE statement, select only one column to have the specified attribute.

For an ALTER TABLE statement, a column with one of the specified types already exists for the table. Do not attempt to add another column with the same data type.

SQLSTATE

428C1

End of change