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


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

   
 
  • Causa
    • THE RESULT TYPE type-1 OF THE SOURCE FUNCTION CANNOT BE CAST TO THE RETURNS TYPE type-2 OF THE USER-DEFINED FUNCTION function-name.

      In order for the CREATE FUNCTION for a sourced user-defined function to be valid, the result type (type-1) of the source function must be castable to the RETURNS type (type-2) of the function being created.
      There is no supported cast between these data types.
      See the DB2SQL Reference for details on casting between data types.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Change the RETURNS data type or the SOURCE function identified so that the result type of the SOURCE function is castable to the RETURNS data type.

      SQLSTATE: 42866

© Copyright IBM Corp.