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


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

   
 
  • Causa
    • CREATE STATEMENT FOR USER-DEFINED FUNCTION function-name MUST HAVE A RETURNS CLAUSE AND: THE EXTERNAL CLAUSE WITH OTHER REQUIRED KEYWORDS; THE RETURN STATEMENT AND PARAMETER NAMES; OR THE SOURCE CLAUSE.

      A required clause is missing in the CREATE for function function-name.
      • For an EXTERNAL function, specify EXTERNAL and one of the following:
        • LANGUAGE
        • PARAMETER STYLE
      • For an SQL FUNCTION, specify a RETURN statement, and a parameter name for each parameter.
      • For a user-defined SOURCE FUNCTION, specify the SOURCE class.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Add the missing clauses or statement, and reissue the failing statement.

      SQLSTATE: 42601

© Copyright IBM Corp.