DSNH372I E csectname ONLY ONE ROWID, ROW CHANGE TIMESTAMP, SECURITY LABEL OR IDENTITY COLUMN IS ALLOWED IN A TABLE

Explanation

An attempt was made to do one of the following actions:
  • Create a table with more than one ROWID column.
  • Add a ROWID column to a table that already has one.
  • Create a table with more than one identity column.
  • Add an identity column to a table that already has one.
  • Add a security label column to a table that already has one.
  • Create a table with more than one security label column.
  • Create a table with more than one row change timestamp column.
  • Add a row change timestamp column to a table that already has one.
  • Create a table without a security label in the Common Criteria environment which requires a security label column on every table created.

System action

The statement cannot be executed.

User response

For a CREATE TABLE statement, select only one column to have the row ID data type, the IDENTITY attribute, the SECURITY LABEL attribute, or the row change timestamp attribute. For an ALTER TABLE statement, a ROWID column, identity column, or security label column already exists for the table. Do not attempt to add another column with the data type row ID, with the AS IDENTITY attribute or the AS SECURITY LABEL to the table. If the Common Criteria environment is set (DSN6SPRM COMCRIT= YES), then every table created must have a security label. Designate a column AS SECURITY LABEL or change the subsystem parameter.

Severity

8 (error)