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


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

   
 
  • Causa
    • ATTEMPT TO CREATE A NULLABLE ROWID OR DISTINCT TYPE COLUMN column-name.

      A CREATE VIEW statement attempted to create a new view with a nullable ROWID column.
      ROWID columns (or distinct type columns for which the source type is a ROWID) do not support null values.
      One of the following situations has occurred:
      • The subselect of a CREATE VIEW statement involves an outer join for which a column of the result table is a ROWID column that needs to allow for null values.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Change the content of the statement so that it does not try to create a ROWID column which must allow for null values.

      SQLSTATE: 42831

© Copyright IBM Corp.