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


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 -492
   
 
  • Causa
    • THE CREATE FUNCTION FOR function-name HAS A PROBLEM WITH PARAMETER NUMBER number.
      IT MAY INVOLVE A MISMATCH WITH A SOURCE FUNCTION

      The parameter in position number of function function-name is in error.
      The parameter in position number of the source function is not castable to the corresponding parameter of the function being created.
      If the parameter of the function being created is a table parameter then the corresponding parameter of the source function must also be a table parameter.
      Furthermore, the column numbers for both of the table parameters must be the same.
      If the parameter of the function being created is not a table parameter then the corresponding parameter of the source function must also not be a table parameter.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Possible corrections include:
      • Identify a different source function.
      • Change the data type of the parameter of the function being created so that the data type of the source function can be cast to this data type.

      SQLSTATE: 42879

© Copyright IBM Corp.