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


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

   
 
  • Causa
    • A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN NAME

      The specification of a column function (AVG, MAX, MIN, or SUM) was invalid because such functions must include a column name in the operand.
      In a trigger definition, a transition variable specification does not qualify as a column name for this purpose.
  • Ação do sistema
    • O comando não pode ser executado.
  • Resposta ao Desenvolvedor
    • A column name must be specified as an operand to the function.
      Refer to Chapter 3 of DB2 SQL Reference for information about the proper usage of column functions.

      SQLSTATE: 42901

© Copyright IBM Corp.