SQL - SQLCODE's - Códigos negativos -601


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -601
   
 
  • Causa
    • THE NAME OF THE OBJECT TO BE CREATED OR THE TARGET OF A RENAME STATEMENT IS IDENTICAL TO THE EXISTING NAME name OF THE OBJECT TYPE obj-type

      One of the following situations has been detected:
      • 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 FUNCTION, and a CREATE DISTINCT TYPE statement failed, then there is already a cast function existing with the same name as the distinct type and an input parameter of the source type or there is already a cast function existing with the same name as the source type and an input parameter of the distinct type name.
      • A RENAME statement specified a target name name, but an object with the same name is already defined in the DB2 subsystem.
  • Ação do sistema
    • The CREATE, ALTER or RENAME statement cannot be executed.
      No new object was created, no existing object was altered, and no existing object was renamed.
  • Resposta ao Desenvolvedor
    • Either drop the existing object or choose another name.
      If obj-type is data set, do an IDCAMS DELETE of the data set before retrying the CREATE.
      Refer to Chapter 2 of DB2 SQL Reference for information about the scope of object names in DB2.

      SQLSTATE: 42710

© Copyright IBM Corp.