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


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 -397
   
 
  • Causa
    • THE OPTION GENERATED IS SPECIFIED WITH A COLUMN THAT IS NOT A ROW ID OR DISTINCT TYPE BASED ON A ROW ID.

      GENERATED was specified in a CREATE or ALTER TABLE statement for a column with a data type that is not a row ID, and is not a distinct type that is based on a row ID.
      GENERATED can only be specified for a column with a data type of row ID, or a distinct type that is based on a row ID.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the statement.
      Either eliminate the GENERATED clause or ensure that the data type of the object is row ID.

      SQLSTATE: 428D3

© Copyright IBM Corp.