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


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 -603

   
 
  • Causa
    • A UNIQUE INDEX CANNOT BE CREATED BECAUSE THE TABLE CONTAINS ROWS WHICH ARE DUPLICATES WITH RESPECT TO THE VALUES OF THE IDENTIFIED COLUMNS.

      The index defined in the CREATE INDEX statement could not be created as unique because the specified table already contains rows that are duplicates with respect to the values of the identified columns.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Examine the data to ascertain whether or not the duplicate data is valid.
      Alternatively, consider creating a nonunique index.

      SQLSTATE: 23515

© Copyright IBM Corp.