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


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

   
 
  • Causa
    • ATTEMPTED TO INSERT AN INVALID VALUE INTO A ROWID COLUMN.

      When inserting into a table, a value specified for a ROWID column was invalid.
      Only row ID values previously generated by DB2 are valid.
  • Ação do sistema
    • The INSERT is not performed.
  • Resposta ao Desenvolvedor
    • Do not attempt to generate any value for insertion into a ROWID column.
      Insertion into ROWID columns is supported for purposes of Data Propagation, where DB2 has previously generated the row ID values.
      Only row ID values previously generated by DB2 can be used as values for insertion into a row ID column.
      Alternatively, insert the row specifying DEFAULT for the ROWID column or remove the ROWID column from the insert column-list.

      You may also use the OVERRIDING clause as a possible solution for this situation.
      See INSERT in DB2 SQL Reference for more information about the OVERRIDING USER VALUE clause.

      SQLSTATE: 22511

© Copyright IBM Corp.