KFAA30601-E
"aa....aa"."bb....bb" of cc....cc is duplicated. (M+J+O)
The table name, index name, or constraint name specified in one of the following SQL statements is already in use: <SQLSTATE: 42I13>
-
ALTER TABLE statement
-
CREATE TABLE statement
-
CREATE INDEX statement
-
CREATE VIEW statement
This also applies to the indexes and the constraint names that HADB attempted to automatically define according to the specified uniqueness constraint definition. In addition, this also applies to the indexes that HADB attempted to define for archive range columns according to the chunk-archive specification.
- aa....aa:
-
Schema name
- bb....bb:
-
Table identifier, index identifier, or constraint name
- cc....cc:
-
-
table: Table
-
index: Index
-
constraint: Constraint
-
an archive range column: Archive range column
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
-
If cc....cc is table, index, or constraint
Correct the table name, index name, or constraint name specified in the SQL statement.
-
If cc....cc is an archive range column
The index identifier specified for RANGEINDEXNAME in the chunk-archive specification is already used. Correct the specified index identifier.
-