SQL - SQLCODE's - Códigos positivos - +807


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 +807

   
 
  • Causa
    • THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE OVERFLOW

      An arithmetic expression contains a decimal multiplication that may cause an overflow condition when the statement is executed.
      The problem may be corrected by restructuring the arithmetic expression so that decimal multiplication precedes decimal division or by changing the precision and scale of the operands in the arithmetic expression.
      Refer to Chapter 2 of DB2 SQL Reference for the precision and scale of the decimal multiplication and division results.
  • Ação do sistema
    • A valid package will be created if no errors are detected.

      SQLSTATE: 01554