← All errors

SQLCODE -601

SQL0601 Object already exists

IBM message text
&1 in &2 type *&3 already exists.
SQLCODE
-601
SQLSTATE
42710

Most common cause

CREATE (or RENAME) of a table, view, index or alias with a name already used in the schema.

Other causes

  • An install script run again.
  • A constraint with a name already in use.

How to fix it

Use CREATE OR REPLACE where allowed, or check first in QSYS2.SYSTABLES.

Related errors

Text and codes from IBM documentation for 7.6. Checked on .