DB2 SQL-Error: -601
SQLState: 42710
Short Description: THE NAME OF THE OBJECT TO BE CREATED OR THE TARGET OF A RENAME STATEMENT IS IDENTICAL TO THE EXISTING NAME OF THE OBJECT TYPE C A RENAME DB S T CREATE ALTER RENAME N P E I IDCAMS DELETE CREATE R C DB SQL R DB
One of the following situations has been detected: v A CREATE statement tried to create an object name of type obj-type, but an object of that type with the same name is already defined in the DB2 subsystem. – If obj-type is CONSTRAINT, the name was specified in the FOREIGN KEY clause, CHECK clause, PRIMARY KEY clause, or UNIQUE clause of either a CREATE or ALTER TABLE statement. All referential integrity, check constraint, primary key, and unique key constraint names defined on a table must be unique. – If obj-type is TABLE or VIEW, and a CREATE ALIAS statement failed, then the alias-name specified in the CREATE ALIAS statement is identical to the table name or view name specified. The TABLE or VIEW might not exist in the DB2 subsystem. – If obj-type is DISTINCT TYPE, and a CREATE DISTINCT TYPE statement failed, then there is already a user-defined type existing with the same name as the distinct type name specified in the CREATE DISTINCT TYPE statement. – If obj-type is FUNCTION or PROCEDURE, and a CREATE FUNCTION or CREATE PROCEDURE statement failed, then there is already a routine existing with the same name as the name specified in the CREATE FUNCTION or CREATE PROCEDURE statement. – If obj-type is PROCEDURE, and a CREATE PROCEDURE statement for an SQL procedure failed, then there may already be an SQL procedure that has the same name as the external name that was implicitly or explicitly specified. – If obj-type is FUNCTION, and a CREATE DISTINCT TYPE statement failed, then there is already a user-defined function function existing with the same name as the distinct type that is specified in the CREATE DISTINCT TYPE statement. – If obj-type is SEQUENCE, and a CREATE SEQUENCE statement failed, then there is already a sequence existing with the same name as the sequence name that was specified in the CREATE SEQUENCE statement.