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


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

   
 
  • Causa
    • THE OBJECT OF A STATEMENT IS AN AUXILIARY TABLE FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED

      An auxiliary table was named in one of the following statements:

      • ALTER TABLE
      • CREATE ALIAS
      • CREATE FUNCTION
      • CREATE SYNONYM
      • CREATE VIEW
      • DELETE
      • DESCRIBE TABLE
      • INSERT
      • SELECT
      • UPDATE

      There are no attributes of an auxiliary table that can be altered.

      Aliases and synonyms cannot be created on an auxiliary table.

      Data in an auxiliary table cannot be accessed by specifying the auxiliary table name in the SELECT, INSERT, DELETE, UPDATE, CREATE PROCEDURE, or CREATE FUNCTION statement.
      Data in an auxiliary table can only be accessed through operations on the base table columns.

  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the statement to specify the corresponding base table instead of the auxiliary table and resubmit the statement.

      SQLSTATE: 560A4
© Copyright IBM Corp.