DSNH612I E csectname LINE nnnn COL cc column-name IS A DUPLICATE COLUMN NAME
Explanation
The CREATE INDEX, CREATE TABLE, CREATE VIEW or ALTER TABLE statement specifies the same 'column-name' for two (or more) columns of the index, table, view, or the UPDATE OF clause of a trigger definition specifies the same column name more than once. Column names must be unique within an index, a table, a view, or in the UPDATE OF clause of a trigger definition. A column cannot be specified in more than one ALTER TABLE clause except if it is specified in an ALTER COLUMN clause and ADD CHECK CONSTRAINT clause.
System action
The statement cannot be executed.
User response
Correct the CREATE statement to specify unique names for each of the columns of the index, table, view, or the columns in the UPDATE OF clause of a trigger definition. Correct the ALTER statement to specify unique names for each of the ALTER COLUMN clauses.
This error can also occur on CREATE TABLE when a column list of a PRIMARY KEY, FOREIGN KEY, or UNIQUE clause contains two or more occurrences of the same column name.
Severity
8 (error)