Previous Topic: -55 - DUPLICATE NAMES IN INSERT/ALTER/CREATE LIST:  aaaaNext Topic: -57 - SPECIFIED MORE COLUMNS OR VALUES THAN THE TABLE HAS


-56 - entity-type entity-name ALREADY EXISTS

Reason:

An attempt was made to create an entity-type with an entity-name or DATACOM name that already exists.

The message text can have multiple formats. In most cases, the text is as shown and the entity-name has the format authid.sqlname. The message text, however, could also be as follows: TABLE USING DATACOM NAME=ttt AND DBID=nnnn ALREADY EXISTS.

The SQLSTATE that equates to this SQL return code is 56S01.

Action:

Verify that the value used for either entity-name or DATACOM name in the CREATE TABLE statement is unique.