PL/I · DB2 SQLCODE

SQLCODE -601: Object Name Already Exists

What does SQLCODE -601: Object Name Already Exists mean in PL/I?

A DDL statement issued for the PL/I application tried to create an object — table, index, constraint — whose name is already in use for an object of that type, frequently from re-running a setup script without dropping the prior objects first.

SQLCODE -601: Object Name Already ExistsDB2 for z/OS · PL/I (embedded SQL)

Condition

A DDL statement issued for the PL/I application tried to create an object — table, index, constraint — whose name is already in use for an object of that type, frequently from re-running a setup script without dropping the prior objects first.

Fix

Drop the existing object first if replacement is intended, or choose a distinct name; check SYSIBM.SYSPENDINGOBJECTS if the object is part of an online schema change that hasn't completed yet.

Related db2 sqlcode