In this post, you’ll learn about the error message -612 column name is a duplicate column name in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-612 column name is a duplicate column name
Reason for the Error
The CREATE INDEX or CREATE TABLE or CREATE VIEW statement specifies the same ‘column name’ for two (or more) columns of the index,table, or view.� Column names must be unique within an index, a table, or a view.
Solution
Correct the CREATE statement to specify unique names for each of the columns of the index, table, or view.