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


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

   
 
  • Causa
    • TABLE table-name CANNOT HAVE A LOB COLUMN UNLESS IT ALSO HAS A ROWID COLUMN.

      An attempt was made to create a table with a LOB column or to add a LOB column to a table, but the table does not have a ROWID column. A table with a LOB column must also have a ROWID column.
  • Ação do sistema
    • The statement was not executed.
  • Resposta ao Desenvolvedor
    • If creating a table with a LOB column, define a column with type ROWID in the same table.
      If using ALTER to add a LOB column to a table, first use ALTER to add a column with type ROWID to the table.

      SQLSTATE: 530A6
© Copyright IBM Corp.